Single Frontend...Multiple Backends 1

[shannonp]

I know there are various solutions to this problem...I was just wondering what would be the best....heres the scenario:

ONE frontend with all forms and queries setup.
Multiple backends with exactly the same table structure.

I have set up a form in the frontend that lists (within a listbox) the fully qualified names of each backend database.

Question: What is the best (fastest) way to link any ONE of the selected backends to the frontend?.

Would be thankful for any advice...

 

[tonyireland]

This Microsoft article tells you most of what you need to know

http://support.microsoft.com/default.aspx?scid=kb;en-us;181076

 

[shannonp]

Thanks...I'll check it out.

 

[shannonp]

Yep that helped...thanks again Tony.