A Microsoft Office (Excel, Word) forum. OfficeFrustration

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.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Database Design
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

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



 
 
Thread Tools Display Modes
  #1  
Old February 2nd, 2005, 02:44 PM
tlyczko
external usenet poster
 
Posts: n/a
Default 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  
Old February 2nd, 2005, 03:25 PM
Rick Brandt
external usenet poster
 
Posts: n/a
Default

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  
Old February 2nd, 2005, 08:38 PM
tlyczko
external usenet poster
 
Posts: n/a
Default

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

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

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


All times are GMT +1. The time now is 02:20 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.