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]