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
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