Data Acces Page from Wizard - where does path come from?

message from ArtIgnacio on 13 May 2004

I have used the wizard to create a data access page. The
HTML shows a data source with a path with the full path on
my machine. I edit it to reflect the relative path. That
is, the page and the database are in the same directory.
It works locally. I post it to the web site, but it gets
an error message that the database can't be found, showing
a path with a C:\WINDOWS etc as the path it's using. Where
does that path come from in the data access page?

=?Utf-8?B?U2hhbm5vbg==?= replied to ArtIgnacio on 13 May 2004

Check out the following document in the knowledge base to get it to work.

http://support.microsoft.com/default.aspx?scid=kb;EN-US;291783

Make sure you have UseRemoteProvider to true if you are hosting the DAP to the web. It tends to reset to false if you make any changes to the Connection String in Access.

I have not been able to get any of the Access DatatBase Security functions to work as stated in http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnacc2k2/html/deploydap.asp
under the heading "Authenticating Users of Data Access Pages Connected to an Access Database" on an IIS 6 web server.

Good luck.

Archived message: Data Acces Page from Wizard - where does path come from? (MS Access Database)