Question about linked tables

[yhgtbfk]

I have done alot of search on the forums and cant quite find the answer.

Is it possible to have the user tell the FE database the file path of the BE and then have code run automatically to refresh the links?

I have a database that I want to lock all users out of. Yet the FE can be located anywhere, and the BE can be located anywhere. What I want to do is for there to be a set up screen where the user can simply type in the path of the data, click on a button, and the database does the rest.

The linked tables manager isnt an option because I want to limit the menu.

If it is possible for me to have a command button, where if clicked, it opens up the linked tables manager, that will also be very helpful.

Thank you

 

[ScottGem]

You should be able to adapt the code found on these two pages to do what you want.

The first page:
http://www.mvps.org/access/tables/tbl0009.htm
has code modules to relink tables.

The second page:
http://www.mvps.org/access/api/api0001.htm
has code to use the standard Windows File>Open dialog to select a file.