Using Linked Tables in Access97

From: Date: Fri, 30 Jun 2000 20:48:22 +0000
Subject: Using Linked Tables in Access97
Groups: php.windows 
Request: Send a blank email to php-windows+get-779@lists.php.net to get a copy of this message
Has anybody had any problems with Linked tables in Access97 while using PHP in IIS4 as an ISAPI module? I cannot access a linked table that resides on a network drive. (in actuality the files are on the web server but have to be accesses throught a "share" becuse of user requirements) I have a file called dbase1.mdb that has linked tables to dbase2.mdb which is on a network drive. while testing the installation I get an error when trying to select from a linked table. The error I get is: "Warning: SQL error: [Microsoft][ODBC Microsoft Access Driver] The Microsoft Jet database engine cannot open the file 'g:\dir\subdir\file2.mdb'. It is already opened exclusively by another user, or you need permission to view its data., SQL state S1000 in SQLExecDirect in d:\Inetpub\wwwroot\odbctest.php on line 6" in the above example drive G is the network drive I'm going throught an odbc dsn which points to a file on the local drive. I've tried pointing the DSN to the "network" drive, but I get a simular error saying "cannot open the file '(unknown)'", instead of "file 'g:\......'". It will work if the DSN is pointed to a local drive and the table is local to the database but once I try to use the network it craps out, so it seems like some sort of security issue. Does anybody know how to fix this? Thanks.

« previous php.windows (#779) next »