Results 1 to 2 of 2
  1. #1
    Join Date
    Jul 2004

    Exclamation Unanswered: 2 DB, one works fine other doesn't, help!

    I've been doing some work on a test database, and it's been working fine, But when i do the exact same things with the database i actually want to use, i get an error message saying:

    Warning: odbc_connect(): 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\Tutorials\prdtTest.php on line 4
    Connection Failed:

    from a simple code:

    if (!$conn)
    echo("Connection Failed: " . $conn); 
    What can i do from here? I have already checked the database properties, and both are alike so i don't think it's a sharing issue. And i have not opened the DB while trying to do this and it is a local file so nobody else can open it.


  2. #2
    Join Date
    Sep 2003
    Permissions ... Permissions ... Permissions. Check your permissions. What user account are you using to connect with?
    Back to Access ... ADO is not the way to go for speed ...

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts