Linked Tables Location on web server

  • Thread starter Thread starter Lin Gar
  • Start date Start date
L

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.
 
Sorry, Access doesn't support relative references. You'll have to determine
what the correct location is on the webserver, and use that.
 
Back
Top