I am trying to connect to a pre-existing access database that has a workgroup database for security. As far as I know the only way to connect to access using PHP is with an ODBC connection. I've got the connection set up to the database and I set the system (same as workgroup?) to the security database however I can't get php to connect.
I get an error that reads:
[Microsoft][ODBC Microsoft Access Driver] Cannot start your application. The workgroup information file is missing or opened exclusively by another user.
Just wondering if anyone knows how to connect to an access database using a security workgroup? Any help would be greatly appreciated.