Is it possible to link to tables in multiple databases??

[tlyczko]

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

 

[Rick Brandt]

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.

 

[tlyczko]

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