Relinking to one of multiple backends using code

[SUSANVV]

I don't know if this belongs here or in the VBA forum. I have one front end (only one user) with several backend databases, each with several tables. I want to be able to relink to only one backend at a time that the user will select from a drop down. All the code that I see seems to connect to all backends at once. When finding all the tables for a specific backend by looping through the tabledefs, do I specify the table and the database and if so, how? TIA for all of your help.

Sue

 

[TheAceMan1]

How are ya SUSANVV . . .

How are you handling this on the form level! ... Do the backends all have the same table & field names?

[blue]Your Thoughts? . . .[/blue]

See Ya! . . . . . .

Be sure to see thread181-473997
Also faq181-2886

 

[SUSANVV]

Thanks for the reply. Yes, the backends are all identical. Each backend represents a project that needs to be kept separate for specific partners for each project. Also some of the data for each backend is imported through ODBC links from different data sources, but all having the same field names. TIA again. Sue

 

[PHV]

Have a look here:

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

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[SUSANVV]

Thanks for the reply. Basically it looks like I open the appropriate backend first and then loop through the tabledefs so that only the tables for that specific backend are relinked. Is that correct as to what will happen? TIA. Sue

 

[SUSANVV]

I appreciate the answers. I need to make sure my procedures are gk. Here is what I did: I have the original database which I will use as the frontend. I made 2 copies of the entire database giving each a different name-these will be the backends. I then deleted the tables from the frontend. I then did Get External Data-Linked Tables and linked the tables from both back ends (I got the same table names but with a 1 after the table name for the second backend). I then deleted the table links in my frontend. I created my form to choose which backend I want and wrote the code as per many codes that I have seen. I kept it simple, even hardcoded one in just for testing. Did I do that right? TIA for your help.