Accessing Multiple Databases

[Guest]

I have six different database that I want to have access to via one form. Is
it possible to have one form with buttons to open each of my databases
similar to a switchboard that gives me access to each object in the current
database? If so how can I do it? Thanks very much.

 

[Jeff Boyce]

One approach would be to first link to the tables in all six dbs. Then your
switchboard could set a form's ControlSource property to the table needed.

By the way, are all six of these dbs essentially "identical" in structure?
If so, why have six?

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[Guest]

No, they are not identical in structure, they are all different. I just
wanted to have access to all the dbs from one central location for easy
access for users, instead of having them closing and opening each one as
needed.

 

[Jeff Boyce]

In that case, since the data coming from each would be different, you'd
probably want to use six (or more) different forms and have the switchboard
open the appropriate form.

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[Pieter Wijnen]

I think what he wants is to shell out to the different applications from a
single switchboard
you can use the Shell Function to do that or look in

http://www.mvps.org/access/api

for shellexecute

HTH

Pieter