Link Table to DBF file on Network Server
Posted on 2006-03-24
I have the following problem, hope someone can help.
I have an Acccess Database on a Windows 98 machine that has linked tables to DBF files on a Novell Network Server and everything works fine. (With a mapped network drive)
However, when I have the same situation on an XP machine, I get the error "The Microsoft Jet Database engine cannot open the file .... it is already opened exclusively by another user, or you need permission to view its data."
When I try to access the same DBF fiels through an asp file on the same pc, the error is "ODBC microsoft access driver, XXXX is not a valid path make sure that the path name is spelled correctly and that you are connected to the server on which the file resides".
(When the DBF file is local, everything works ok)
I have tried everything except the right solution... review permissions, map the drive, use a UNC path, etc, etc, etc. I'm just about to give up.
Thanks in advance for any help on this.