Choose back end

[KP]

I have a split database. Is it possible to choose a different back end at run time?

Thanks in advance.

 

[Allen Browne]

Yes, you can set the Connect property of the TableDef, and remember to
RefreshLink.

If you want to give the user the Windows FileOpen dialog so they can select
the file, see:
http://www.mvps.org/access/api/api0001.htm