RE: [PHP-DB] ODBC MSAccess2000

Hi Melissa, It's possible that Access is doing something like opening it in read-only/single-user mode, and then trying to open it again. The best way to see what is happening is to set up a trace. There is a tracing tab in the ODBC Administrator - start tracing there, and then test your DSN by, say, trying to import data from that Access DB into Excel. Hope this helps! Best regards, Andrew ---------------------------------------------------- Andrew Hill Professional Services Consultant OpenLink Software http://www.openlinksw.com XML & E-Business Infrastructure Technology Provider > -----Original Message----- > From: Melissa Anderson [mailto:melissa.anderson@milesmedia.com] > Sent: Monday, September 25, 2000 8:57 PM > To: php-db@lists.php.net > Subject: [PHP-DB] ODBC MSAccess2000 > > > I get the following error when I try to connect via ODBC to an Access2000 > database. This was working 3 days ago and seems to have suddenly > stopped. No > one is in the database, I have setup a brand new database and > System DSN and > can't seem to figure out this error...permissions were fine before and > should still be...any ideas? > > 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 > C:\InetPub\wwwroot\catalog\index.php3 on line 3 > > -Melissa Anderson > Miles Media > melissa.anderson@milesmedia.com > 319-265-2523 > 509-271-8570 fax > > > -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe, e-mail: php-db-unsubscribe@lists.php.net > For additional commands, e-mail: php-db-help@lists.php.net > To contact the list administrators, e-mail: php-list-admin@lists.php.net > >