link tables

[CHTHOMAS]

<br>
I have developed a project status control database. I have to keep track of 10 projects. For each project distinct directories exists. My client wants the db to function in the following way.<br>
<br>
1) The back end for each project should reside in the respective project's directory.<br>
<br>
2) when the user opens the front end the user has to select the project directory where the back end resides.<br>
<br>
3) Then user has to select the back end database.<br>
<br>
Could anyone help or provide suggestions regarding the followings<br>
<br>
1) In a multiple user environment is it possible to place the back ends in different directories like mentioned above?<br>
<br>
2)If so, when user1 selects the back end in project1 directory, then the table links should be to the back end db in project1<br>
directory. When user2 selects the back end in project2 directory, can the links be automatically modified to back end in<br>
project2 directory? If so what happens to the user1's link to project1 directory.<br>
<br>
3) is there any other better methods or suggestions to split the database or in using the directories.<br>
Any help and suggestions will be appreciated.<br>
Charley<br>
<br>

 

[dblake]

Haven't tried it out yet, but I guess the following will work:<br>
<br>
Copy the front end to each users' PC; the backends I persume reside on a server, or on one of the users' PCs.<br>
<br>
At this stage the frontend can be linked to any one of the project backends - the linked one will be the "default".<br>
If you open a linked table in design view, and then click Properties, you will see the path and other settings used to link the table in the Description property. <br>
<br>
You should be able to change this property dynamically with Visual Basic (as long as the table is not being used somewhere!) (also remember to retain the "other settings" mentioned above). So you can write some code in one of your forms, or even in a start-up module which determines the user that logged on with the CurrentUser function.