Changing Front End Back End Connection Through VBA

[Rishi]

Hi,

In a form in the front-end the location of the backend is mentioned.
(this is the result of a dlookup from a table that holds the locations of
all backends; user chooses which backend to connect to)

How can I define that when the user clicks a connect button, all the tables
in the front end are connected to the back end which is chosen?

Thnx for your help!

 

[Stefan Hoffmann]

hi Rishi,

How can I define that when the user clicks a connect button, all the tables
in the front end are connected to the back end which is chosen?

http://www.mvps.org/access/tables/tbl0009.htm


mfG
--> stefan <--