I tried securing my database with the Access .mdw system. I set the .mdw as the default group file, and inserted the name/password both in my ODBC default login and in the odbc_connect arguments. Both resulted in a "Warning: SQL error: [Microsoft][ODBC Microsoft Access Driver] The Microsoft Jet database engine cannot open the file '(unknown)'. It is already opened exclusively by another user, or you need permission to view its data" error. I know it is not opened by another user so how should I pass my authorization info to msaccess? Is it possible to use db-side security with php/odbc/msaccess?.
