Access Access Daisy Chain Linked Tables

B

billhealy

Joined
Oct 18, 2012
Messages
1
Reaction score
0
I am working on a collection of MS Access DBs. There are several linked tables in each DB, but one table in particular is linked via multiple tables. For example:

DB1 DB2 DB3 DB4
TBL1 <-------------TBL1 <-----------TBL1 <-----------TBL1

So in the example above TBL1 exists locally only in DB4. It is linked to DB3 from DB4, linked to DB2 through DB3, and linked to DB1 through DB2 via DB3

My question is, does this have any sort of performance hit or is there any reason, besides making this collection of databases difficult to work with, not to do this?


Thanks in advance,

Bill
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Referential Integrity on Linked Tables 3
Using multiple SqlConnection objects, bad for performance? 4
Compacting On Close 3
Accessing another mdb file in form of an access file form... 1
Cannot open db1, db2, db3.... 2
Linking Tables from Password Protected DB 2
Linked Tables 1
Opening DAO Recordsets 1

Top