Check the file permissions on the .mdb file. Make sure it is readable by everyone.
Bye, John Paul Lalli <[EMAIL PROTECTED]> wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... > Hello, > I'm just beginning experimenting with MS Access and PHP. I found all the > tutorials online that explain how to create a DSN for my existing Access > database, and went through the procedure fine. The DSN I chose is > "prototype" and the database does not have a username or password. I then > created a very simple script: > > <HTML> > <HEAD> > <TITLE>Access connection</TITLE> > <BODY> > <?php > #Open a connection to an access database > $connection = odbc_connect("prototype","",""); > if ($connection){ > echo "Connection established<br>\n"; > } else { > echo "Connection NOT established<br>\n"; > } > ?> > > When running this file, I get the following output: > > 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 D:\www\Lalli\php\access.php on line 7 > Connection NOT established > > The server is running MS WinNT 4.0 SP6, with PHP 4.0. Can anyone help me > out? > > Thank you, > Paul Lalli > > -- PHP Database 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]