Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 303
  • Last Modified:

daisy chain database linking x -> y -> z

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?
0
billwagnon
Asked:
billwagnon
  • 2
1 Solution
 
Jim Dettman (Microsoft MVP/ EE MVE)PresidentCommented:
<<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.
0
 
billwagnonAuthor Commented:
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.
0
 
VolibrawlCommented:
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.
0
 
Jim Dettman (Microsoft MVP/ EE MVE)PresidentCommented:
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.

Sorry.

Jim.
0

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

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