Data Access Page Setup

[occulus5]

I am having some trouble setting up our data access page on our server. I am
using Access 2003 and Server 2003 and right now our Data Access page works
only if you VPN into our network. I created the Data Access page using the
wizard in Access and i put it in the Inetpub\wwwRoot\ on the server. The data
base is on another hard drive on the sever and is updated regularly. The page
works fine, but i am not sure how to set it up so that it can be accessed
from the internet outside of our network. Currently the path to the .mdb file
is '\\server01\...' What do i need to change so that this page works
properly? Something with the MDAC?

 

[Sylvain Lafontaine]

Short answer: you cannot do this without using a VPN or installing the
security hole called RDS or replacing the mdb file with SQL-Server.

Long answer:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnacc2k2/html/deploydap.asp

 

[occulus5]

So how else can i set it up so that user can see data in our database on the
web in real time?

 

[Sylvain Lafontaine]

With DAP? You can't; unless you replace the MDB file with SQL-Server and
even then, many of your users will be blocked by a firewall on their side.

If you want to go with Internet, then your only practical solution is to
replace DAP with something else; such as ASP.NET.

 

[occulus5]

What about setting up RDS or MDAC? How would I go about doing that?

 

[occulus5]

What about setting up RDS or MDAC? How would I go about doing that?

 

[Sylvain Lafontaine]

MDAC is not a technology: it's only a service pack for data libraries such
as JET, ADO and OLEDB.

For RDS, you can try it if you want to (it's free) but it has been
deprecated by Microsoft many years ago for security concerns. If you take a
look at the reference that I've given in my first answer, you will see that
the date of publication is 1999; this simple fact should tell you all you
want to know about RDS.

 

[occulus5]

What is the simplest and quickest way to set up a webpage that users can
login to and veiw information from our data base then? Ultimatly we want to
be able to connect and view information from our server.

 

[Sylvain Lafontaine]

Well, there are many possibilities but I not familiar with them. A
possibility would be to use something like FrontPage to create an ASP page
that will display the result but the users won't be able to make update to
the database. Another possibility would be to create ASP.NET pages but it's
a lot more complicated.

You should start a new thread and post your question into others newsgroups
such as m.p.access.internet and m.p.frontpage.programming.

 

[occulus5]

With DAP? You can't; unless you replace the MDB file with SQL-Server and
even then, many of your users will be blocked by a firewall on their side.

If you want to go with Internet, then your only practical solution is to
replace DAP with something else; such as ASP.NET.