Linked tables in MS access used by IIS problem
Posted on 2004-04-16
Got a Web-server running IIS. On the local disk got an mdb-file with 2 linked tables to two other mdb-files (tables) located on another server (file-server).
In an ASPscript I'm connecting to a query; this query has information of a table in the local mdb and the 2 linked tables.
Problem: the webbrowser (on a client machine)errors saying the specified drive of the linked tables is not correct.
Tried to fix this by setting up the to remote mdb-files as ODBC's; but the local access won't let me link via ODBC to it.
Anyone a good idea how to solve this?