Setting the location of CurrentDB

[ddcessex]

Scenario:
The database has been split into Data and Code modules
The Database Module resides on the Server in C:\Project
The Code Module can reside anywhere on the user's local hard drive.
Because the location of the Code Module as well as the user's mapping to the server can change between one user and another then I assume that there is a way that you can programatically change the path to the database within the the Code Module?

I understand the use of the Linked Table Manager but this is hard coding the location of the database within the Code Module - I want to try and avoid that.
Any help would be appreciated

 

[MarkK]

What I most commonly do is put the BE on a mapped drive. Then I can put the BE anywhere, and just map a drive to that location. Then I link the FE to the BE on the mapped drive, so maybe "Z:\customer_be.accdb." Then I never have to re-link tables if we move the BE, we just re-map Z:\ to the new BE folder, and then you never have to relink tables from the FE.

 

[ddcessex]

So you use the Linked Table Manager to map all the tables to "Z:\project\db_be.accdb" and use the mapping from each pc on the network to point to that drive letter Z: and the filename.

Sweet - thank you buddy