Linked Tables and forms

[scott04]

Hi everyone,
I had a department ask me the question on whether they can use a switchboard
to link 3 or 4 different databases? I am pretty sure it would be possible as
long as the databases are split correct? Would i just have these linked
tables on the database and have the necessary forms and reports loaded onto
the front end? If someone can offer me their thoughts or a link to were i
can find more information it is appreciated. Thanks

 

[Klatuu]

You can link to multiple back end databases; howver linking only applies to
tables. If you have forms, reports, queries, or macros in the databases you
want to use, you will need to import them into your front end.

 

[scott04]

Dave,
Thanks for you input. So if I do create the switchboard i should do so on
the front end correct?

 

[Klatuu]

Yes.

Just for clarification. A front end consists of all forms, reports,
queries, and macros. It can also contain local tables. That is, there can
be instances where the user using the front end needs acccess to the data.
It also contains the links to all tables. The tables can be in multiple back
ends. It can even be a mixture of mdb files and SQL Server database tables.

To correctly deploy a split database, each user should have a copy of the
front end on their own computers. The bac end files need to be on a shared
folder to which all users have access.

It is not correct to have a front end on a server that multiple users share.
This doubles network traffic for each user and can cause other problems.