Connecting to other DB's on a LAN through FP

[Q45]

I use Frontpage to connect to an Access DB typically held
in the Frontpage default folder of fpdb in the web. I
need to connect to a different database stored on a
server connected to the LAN. Doing a direct copy will
corrupt the DB since it's open somewhere on the LAN
24/7. Replication triples the size of the DB and slows
it down to a snails pace so that won't work. I am
currently linking the tables of the DB in fpdb folder to
the real DB on the LAN. You can open the linked DB
through Frontpage but it won't allow you to create the
connection string using the Frontpage Database results
wizard. Does anyone know of an additional ODBC
connection that I additionally need to create or have any
other ideas? I'm stuck. Thanks for your help!

Q45

 

[Kathleen Anderson [MVP - FP]]

You should be able to modify the connection string in the global.asa to
point to the database on the LAN server - look here for some examples:
http://www.connectionstrings.com/ click on Access ODBC