[PHP-WIN] Using Linked Tables in Access97 From: Bunji (dbudny <email protected>)
Date: 06/30/00

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. 

-- 
PHP Windows Mailing List (http://www.php.net/)
To unsubscribe, e-mail: php-windows-unsubscribe <email protected>
For additional commands, e-mail: php-windows-help <email protected>
To contact the list administrators, e-mail: php-list-admin <email protected>