How to create a shared Data Access (Web) Page

[Guest]

I’m just learning about Data Access (Web) Pages. I can create one and it
works on my PC. I’m unclear how to make a Data Access Page available to
multiple users on an intranet. Just copying the .htm and the .mdb to a
shared folder doesn’t work because the .htm is trying to open the .mdb on my
C: drive.

I can’t find where to change the address in the .htm file to reference the
relocated .mdb.

Do I need to create the Data Access Page from the shared folder? Or can I
change the address in the .htm to reference the .mdb in the shared folder?

 

[Ken Snell [MVP]]

There is a Connection String property for the Page object in each Data
Access Page entity. In that string is the path to the database file. You'll
need to open each page and change that string to the correct path for where
the database will be when users are accessing it.

As you can imagine, this is a pain. It's possible to write VBA code that
will do this.

What I do is create a network drive on my PC that mimics the final
destination, and do all development using the database in the correct folder
in that drive. Then, when I copy the database to the shared location, it's
all set.