Greetings. In my (admittedly limited) experience with Access, these "already opened exclusively by another user" messages indicate one of two things:
1) Someone else is using the database/table at the same time you are trying to access it (e.g. it's locked). You may want to try running your script at a time when no one's around and/or confirming that no one else is trying to use the database (e.g. doesn't have it sitting open on their desktop, so that it's locked, but not really being "used" in the "I'm at work" sense 🙂
2) The database permissions have become corrupted. This is (again, in my limited experience) not an uncommon occurence. Typical solutions I've seen in this case are: restoring the database from backups; reconstructing the database by manually copying the data to a new database file or files; in some other way generating a new binary database file or files from the old data. Sorry...
Anyway, hope that helps - good luck!
-drsteve
Cowboy_X wrote:
I've just written a PHP program that handles file uploads and stores references to the files in a simple Access database. The program and the database worked fine on the development computers (both Win2k workstation, PWS & PHP), but on the actual server (Win2k server, IIS, new installation of PHP) I get this error message:
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., SQL state S1000 in SQLConnect in c:...\actionLogin.php on line 4
I take it that this is a permissions issue? I've made sure that IUSR_xx has full control to the directory holding the .mdb database file. Are there permissions elsewhere that need to be set?
