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.
COURSE of the MONTH
8 days, 18 hours left to enrollBecome a Premium Member and unlock a new, free course in leading technologies each month.
Solved
daisy chain database linking x -> y -> z
Posted on 2003-02-26
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?
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?
[X]
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
4 Comments
Active today
<<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.
Jim.
Should work. From Main, you should be able to see all the tables in Branch both local and remote to Branch.
Jim.
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.
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.
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.
Featured Post
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
Course of the Month8 days, 18 hours left to enroll
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.