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
Sam OZAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

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)President / OwnerCommented:
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

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
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
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

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
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Programming Languages-Other

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.