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
|
|||
|
|||
Is it possible to link to tables in multiple databases??
I have 2 or 3 different Access front ends that would like to link to
one 'common' table of data used by these front ends and the tables specifically associated with these front ends. They would all be on a server. Is this possible, and are there any caveats or gotchas involved with this?? These are presently Access front ends to Access databases, but one or more of the tables might go into SQL tables accessed by Access projects. I imagine that I have to keep it clear what kinds of front ends are accessing the 'common' table of data. Thank you, Tom |
#2
|
|||
|
|||
tlyczko wrote:
I have 2 or 3 different Access front ends that would like to link to one 'common' table of data used by these front ends and the tables specifically associated with these front ends. They would all be on a server. Is this possible, and are there any caveats or gotchas involved with this?? These are presently Access front ends to Access databases, but one or more of the tables might go into SQL tables accessed by Access projects. I imagine that I have to keep it clear what kinds of front ends are accessing the 'common' table of data. Thank you, Tom There is no problem with multiple front ends connected to a single back end. That is in fact the preferred setup for multiple users. The only caveat with one front end to multiple back ends is that you cannot enforce referential integrity between two tables that don't reside in the same database and (I think) queries between such tables cannot be optimized and might run slower. Other than that there is no problem. My main application has links to Text files, Excel files, Two different SQL Servers, an IBM ISeries database, and I believe one Jet file. -- I don't check the Email account attached to this message. Send instead to... RBrandt at Hunter dot com |
#3
|
|||
|
|||
Thank you for replying.
I plan to only read/get data from one of the backends into another backend and I don't have a LOT of users, so my plan should work okay. I just have to be careful what I do. Thank you, Tom |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Sudden database corruption of multiple databases. | Karen | General Discussion | 4 | December 15th, 2004 08:35 AM |
Can I update tables from a form using query with multiple tables? | aitkenss | General Discussion | 1 | September 8th, 2004 11:45 PM |
Linking multiple tables together | Karl Albrecht | Database Design | 1 | September 1st, 2004 12:00 PM |
Need help with Tables Design and Relationships | Tom | Database Design | 24 | May 19th, 2004 06:51 PM |
Creating web link with data from multiple cells and a image as the link | James | Links and Linking | 3 | April 30th, 2004 07:08 PM |