Access Linked Tables location on web server

[Lin Gar]

My web site is using 1 huge Access Database.

I tried to distribute the tables among several .mdb files
in order to facilitate updating process and link them to a
main mdb file. However linked tables use fixed location
reference (ex. c:\Myweb\1.mdb) . ASP pages (with DNS or
DNSless connections) no longer work as the main mdb file
will be looking for c:\Myweb\1.mdb on the web server.

Is there a way i can make the reference relative (1.mdb
if in same directory) as it is impossible to specify fixed
location when posting databases on web servers.

 

[Ted]

I have been able to link tables using UNC by just typing
in the path and file (in the filename field), rather than
choosing the file, in the link table dialog box. I have
only tried specifying the full network path, not a
relative path, but it is possible that would also work.
Try typing in the path and file name rather than choosing
the file when linking the table and see what happens.

-Ted