daisy chain database linking x -> y -> z

Posted on 2003-02-26
Medium Priority
Last Modified: 2008-03-10
The Access system I am working on has this structure:

Main MDB
Branch MDB
Branch2 Visual FoxPro database

Main acts as a switch and the user can change the links to use other Branch databases.

Currently, the Visual FoxPro tables are linked to Main, and tables in Branch are linked to Main.

What I would like to do is put a password on Branch, and run all the linking through that table, preferably using ODBC.  But when I attempt to link Branch from Main, I can't see the VFP Branch2 tables.  Can you string links like this or is a direct link the limit?
Question by:billwagnon
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
LVL 58
ID: 8025838
<<But when I attempt to link Branch from Main, I can't see the VFP Branch2 tables.  Can you string links like this or is a direct link the limit?>>

 Should work.  From Main, you should be able to see all the tables in Branch both local and remote to Branch.


Author Comment

ID: 8025951
I thought it might be an issue of using Access to connect to VFP, but I tried linking a 3rd access mdb table into Branch, and I can't see it when linking Main to Branch.  I can only see the native Branch tables.

Accepted Solution

Volibrawl earned 200 total points
ID: 8026025
We may have found a 1% !!

Jim is NEVER wrong and RARELY misunderstands the question, but in this case ... hmmm.

I don't think you can "link" to a "linked" table.
LVL 58
ID: 8026138
Well I guess I can't say never anymore<g>  I could have sworn that in the past I linked to a linked table, but I just tried it and it does not work.



Featured Post

Get your Conversational Ransomware Defense e‑book

This e-book gives you an insight into the ransomware threat and reviews the fundamentals of top-notch ransomware preparedness and recovery. To help you protect yourself and your organization. The initial infection may be inevitable, so the best protection is to be fully prepared.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Did you know that more than 4 billion data records have been recorded as lost or stolen since 2013? It was a staggering number brought to our attention during last week’s ManageEngine webinar, where attendees received a comprehensive look at the ma…
This article shows how to get a list of available printers for display in a drop-down list, and then to use the selected printer to print an Access report or a Word document filled with Access data, using different syntax as needed for working with …
Get people started with the utilization of class modules. Class modules can be a powerful tool in Microsoft Access. They allow you to create self-contained objects that encapsulate functionality. They can easily hide the complexity of a process from…
Learn how to number pages in an Access report over each group. Activate two pass printing by referencing the pages property: Add code to the Page Footers OnFormat event to capture the pages as there occur for each group. Use the pages property to …
Suggested Courses

764 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question