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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Changing Front End Back End Connection Through VBA 1
space limitation for MS Access front end application 3
Copying back-end files from the front-end. 4
Delete current record from front and back end 7
front end and back end 4
Performance Issues with split database 2003/2007 1
main form has back-end table data source 3
Network connection front end and back end 0

Top