Data Access Page will not connect to dB on web server

M

Marc

Access 2002
I sure would appreciate help for this one.

I've deployed a DAP connecting to an Access mdb file onto
the web server. Both in the same folder. I have other
ASP's connecting to this dB without any problems. The DAP
has the following connection string, which works fine in
my ASPs.

E:\Sites\www8.nb.prv\Operations\NSM\DWS\DocumentInventoryLi
st.mdb

and this is the URL:

http://www8.nb.prv/ops/nsm/dws/DocumentInventoryList.htm

The DAP, however does not connect to the database. I get
the following error:

An error occured trying to use "Document", Check to see
that the object exist.

Document being the name of the table that I am querying.

As far as I know, the web server is configured and has the
components to deal with a DAP. I have set
useRemoteProvider to True, and set the browser security to
low.

I've been trying to get this working on the web server for
two weeks now. The DAP was connecting to my hard drive
and working great, but since changing the connecting
string for the web environment - no go.

Did I miss something? I may not be able to develop with
Access for the web, if this can't be resolved soon. It is
a great way to make data available to many users though.

Marc
(e-mail address removed)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top