• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 391
  • Last Modified:

Chain linking in MS Access

Hi Experts,
 
    I have  Db1 linking to all tables in Db2 .   Now Can Db3 link all the Tables in DB2 ( which are already links)  ?

   Either a macro or some procedure in MS-Access is fine for me

   Thanks

   Sam
0
Sam OZ
Asked:
Sam OZ
1 Solution
 
Dale FyeCommented:
yes,

You can link from multiple front-ends to the same Access backend.

User the External Data option on the ribbon, then select Access as the data source.  

Then browse to and select the table you want to link tables from.

Then indicate that you want to link the tables (radio button).
0
 
Jim Dettman (Microsoft MVP/ EE MVE)PresidentCommented:
No.  You can not link to a linked table in another DB.   You can only link to a table if the DB actually contains the table.

Jim.
0
 
Sam OZAuthor Commented:
Thanks Jim .  Just leaving it open for a little more time

 Just a LITTLE EDIT ON THE QUESTION , IF IT IS NOT STATED CLEARLY ....
.
   I have  Db2 linking to all tables in Db1 .   Now Can Db3 link all the Tables in DB2 ( which are already links)  ?  - In Db2 there are no Tables present . All are links
0
Transaction-level recovery for Oracle database

Veeam Explore for Oracle delivers low RTOs and RPOs with agentless transaction log backup and transaction-level recovery of Oracle databases. You can restore the database to a precise point in time, even to a specific transaction.

 
Dale FyeCommented:
Sorry, I misunderstood, and Jim is correct.

I though you wanted to link from DB1 tables to DB3.
0
 
Gustav BrockCIOCommented:
From db3 you can import all table objects from db2. However, select only those that link to db1.

/gustav
0
 
Scott McDaniel (Microsoft Access MVP - EE MVE )Infotrakker SoftwareCommented:
You can also have tables from multiple data sources in your DB3 - so you could link tables from DB1 and tables from DB2 in your DB3 database.
0

Featured Post

How to Use the Help Bell

Need to boost the visibility of your question for solutions? Use the Experts Exchange Help Bell to confirm priority levels and contact subject-matter experts for question attention.  Check out this how-to article for more information.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now