I've just tried creating an entirely new database and receive the same error as well as reparing the old database. I've restarted the web server, still the same problem. The access 2000 db is on an iis 4.0 server which worked fine previously. Thanks, Aaron "Gonzalo Vera" <[EMAIL PROTECTED]> wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... This usually happens when another user opens a table for modification (table definition): the table gets locked to all access. If you're only running localhost try "repairing" your database: maybe you got a corrupted table or db. Also if you're only on localhost, restart your computer to make sure all files get closed. If you're not only running localhost, and the database is on a remote server, you might have some more trouble, but still would need to do some/all of these actions. That was like a gunshot, but it has worked for me in the past... ;) Gonzalo. > Up till late yesterday I was able to query my database but now I receive > this error. > 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., SQL > state S1000 in SQLConnect in wwwroot\test.php on line 2 > My script is only trying to make a connection at this time and it does not > work > <?php > $cnx = odbc_connect (equipment2,'',''); ?>> > What went wrong? Thanks, > Aaron -- PHP Windows Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED] -- PHP Windows Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
