Using Linked Tables in Access97
| From: | (Bunji) | 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.