Access Linked Tables and IIS/ASP

[Stu]

I have a few FrontPAGE 2002 Webs running on Windows 2003 Servers and
IIS. My webs use ASP (classic) pages that display data pulled from
the Access databases using the FrontPage database results wizard -
displaying query results, etc. from my main database. It works fine
when the database contains the tables/data but when the tables are
linked to external tables within *.mdb files (located in the same web
folder - /fpdb) or if I split the database (main mdb1 with
querys/reports/linked tables + mdb2 with tables/data) the ASP results
won't run. The ASP Page error goes like this:

Database Results Error
Description: 'C:\Documents and
Settings\xxxx\xxxx\xxxx\xxx\xxx\xxx\fpdb\server.md b' is not a valid
path. Make sure that the path name is spelled correctly and that you
are connected to the server on which the file resides.
Number: -2147467259 (0x80004005)
Source: Microsoft JET Database Engine

It seems that Access is using the absolute path from my local C: drive
to look for the linked table(s) instead of the relative path where the
mdb(s) resides on the web server. All of my databases are in the same
/fpdb folder within a FrontPage Web.

Any help would be appreciated!