blade690
Posts: 13
|
| Posted: 10/27/2006, 8:53 AM |
|
Hello,
I am having a problem using linked tables in MS Access and Apache. I have half my tables in the local database and half are linked to an external database using UNC to another database on the network/server.
i.e. LinkedTable mapping: \\ServerName\C\databases\database.mdb
I have users who open up the database locally as well via Access so I need the UNC naming, otherwise it breaks as Access looks for the tables locally if I link it with C:\databases\database.mdb for example.
Warning: odbc_exec() [function.odbc-exec]: SQL error: [Microsoft][ODBC Microsoft Access Driver] The Microsoft Jet database engine cannot open the file '\\Earth\C\databases\database.mdb'. It is already opened exclusively by another user, or you need permission to view its data., SQL state S1000 in SQLExecDirect in D:\htdocs\scripts\codecharge\NewProject1\db_odbc.php on line 88
I found an article through Microsoft which seems to be the problem,
"If you access a local Microsoft Access database that is linked to a table where the table linked to is in an Access database on a network server, you receive the following error message"
http://support.microsoft.com/kb/189408/EN-US/
but the solution is for IIS. I am using APACHE as my web server.
Any ideas on how to implement a solution for Apache or any other workarounds?
Thanks!
|
 |
 |
|
