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.

 

[Douglas J. Steele]

Sorry, Access doesn't support relative references. You'll have to determine
what the correct location is on the webserver, and use that.