Re-linking database through code

[John]

Hi

I have a front/back end scenario for my access app. I need to allow user to
connect the front end to one of two back ends at start time. Presumably this
needs linking to the relevant back end using vba code. How is this achieved?

Thanks

Regards

 

[Douglas J. Steele]

There's sample code at http://www.mvps.org/access/tables/tbl0009.htm at "The
Access Web"