By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
425,775 Members | 2,658 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 425,775 IT Pros & Developers. It's quick & easy.

Access Linked Tables and IIS/ASP

P: n/a
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!
Nov 13 '05 #1
Share this question for a faster answer!
Share on Google+

This discussion thread is closed

Replies have been disabled for this discussion.