ODBC connect to *.mdb on mapped network drive?
Posted on 1999-01-06
I'm trying to display the results of a query in an HTML-page that accessible in the intranet. That's why I created *.idc and *.htx files to display the results.
I also set up the data source in ODBC (in the Control Panel).
"Everything" works fine as long as the database resides in c:\whatever. Of course, the database would "normally" be stored on the server. I mapped the directory to X: and changed the data source in ODBC.
However, I'm now getting the following error message:
Error Performing Query
* [State=S1000][Error=-1032][Microsoft][ODBC Microsoft
Access 97 Driver] The Microsoft Jet database engine cannot
open the file '(unknown)'. It is already opened exclusively by another user, or you need permission to view its data.
What could be the problem? Directory was readable for everyone. I'm using Access 97 (as U C above :-), Win NT 4.0 and Peer Web Services 4.0
Any ideas appreciated!