Linking front-end to back-end

M

marc p

I wonder who could help me with this.

I have the front and the back end databases. The back-end
is installed in a common directory from the server. The
front-end has all its tables linked to this location. The
problem is when (1) I change the back-end location, or (2)
I would like to change the back-end for one with the same
structure but different data. Then the linked tables at
the front-end continue referring to the previous back-end.

Is there any way for the user to specify the new location
of the back-end? I know it can be done trough Tools-
Database Utilities - Linked Table Manager, but I would
like to do it directly from the front-end database by
programming a form called "specify back-end location".

Thank you,

marc
 
Top