Linked tables from remote location

[Cprice]

I have a FE database with all the forms, reports, etc. and my BE DB with all the tables is in the same directory as the FE. My problem is when users are not in the office and opens the FE data base they get an error that the path to the linked tables are not available.

My question: Is there a way to make these FE links to the BE dynamic. I really don't want various FE with paths linked to the BE.

 

[Ian Mac]

I have a FE database with all the forms, reports, etc. and my BE DB with all the tables is in the same directory as the FE. My problem is when users are not in the office and opens the FE data base they get an error that the path to the linked tables are not available.

My question: Is there a way to make these FE links to the BE dynamic. I really don't want various FE with paths linked to the BE.

Hello,

Not sure how you can have the FE in the same directory as the BE, the point of the FE is that it is Client side.

Also, how do they log in for outside of the office??

One thing which may work for you is to locate the Directory through the Network, NOT I:\Path\Database.mdb BUT \\Server\Path\Database.mdb
When they lod onto the server the path will be available.

Regards,

 

[Cprice]

Both the FE and BE are on a shared computer we use like a server running windows XP SP2, We have Access XP SP3

Path to both files is "\\Servidor\PEP411254852\BaseDeDatos" the FE has linked tables form the BE using this path. From inside our office (LAN) this works fine.

From outside our LAN or a remote location connecting using a VPN this path is not valid. The path changes to a mapped drive "Y:\PEP411254852\BaseDeDatos"

The only thing I found works is two FE one with links to the BE using the LAN path and another FE with links to the BE using VPN path.

Depending on your location you open the appropriate FE file.

I was hoping there was a way to make this dynamic with VB code or some other means. It's a pain having to maintain the two FE files and each time updates or changes are made to the FE having to relink the paths for each file.

I realize that not everything is possible and if I have to live with the pain then that’s OK. Any suggestions are welcome.