How to Dynamic Link Table?

[Suraj]

Dear Friends,
I have a spilt database of tables in back-end and forms,
queries, reports in front-end. In the front-end, I have
linked the tables using the 'Linked Table Manager.' Also,
I have created a Startup Form in the fron-end.
My question is that, is there any way that when I open
the front-end, I can get a dialog box to enter the back-
end path?
Perhaps, I move the data files (backend), can the I
change the path dynamically without running the 'Linked
Table Manager?'
Regards,
Suraj.

 

[Duane Hookom]

There is code at http://www.mvps.org/access/tables/tbl0009.htm.
_____________
Duane Hookom
MS Access MVP

 

[Suraj]

Thank you for the reply. The web site has excellent
source codes.
Thanks.