If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Linked Tables and forms
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 |
#2
|
|||
|
|||
Linked Tables and forms
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. -- Dave Hargis, Microsoft Access MVP "scott04" wrote: 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 |
#3
|
|||
|
|||
Linked Tables and forms
Dave,
Thanks for you input. So if I do create the switchboard i should do so on the front end correct? "Klatuu" wrote: 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. -- Dave Hargis, Microsoft Access MVP "scott04" wrote: 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 |
#4
|
|||
|
|||
Linked Tables and forms
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. -- Dave Hargis, Microsoft Access MVP "scott04" wrote: Dave, Thanks for you input. So if I do create the switchboard i should do so on the front end correct? "Klatuu" wrote: 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. -- Dave Hargis, Microsoft Access MVP "scott04" wrote: 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 |
Thread Tools | |
Display Modes | |
|
|