Data Access Pages From The Internet?

H

Hermin

Hi. I am trying to set up a data access page that will be accessible from
anywhere on the internet. I have set the connection string on my data access
page to //Blah/C/Blah.mdb. This works great on my LAN, as my computers are
simply able to access the database at //Blah/C. However, it fails when I
attempt to access the data access page from a remote computer. This is
because the remote computers do not have access to //Blah/C/Blah.mdb. Is
there any way to set up the data access page so that it always uses its local
//Blah/C/Blah.mdb as the data source, rather than trying to load it from the
remote computer? Thanks.
 
S

Sylvain Lafontaine

Unless of using a VPN or RDS, the answer is no: the OLEDB protocol for
Jet/MDB cannot be used over the Internet (WAN), only over a LAN.

You will have to replace the MDB with MSDE or SQL-Server as the backend or
to use something else than DAP, like ASP or ASP.NET. You could also use RDS
as the intermediate transport layer but it's now obsolete since many years
because of security concerns.

There is a newsgroup about DAP: m.p.access.dataaccess.pages
 
Top