How to Mimic Access' Externally Linked Tables using ADO?

From: Shawn B (ext.news.1_at_bdenim.ca)
Date: 01/21/05 

Date: Fri, 21 Jan 2005 13:38:30 -0800

Hi All,

I would like to simulate/mimic the behaviour of Microsoft Access'
"Externally Linked Tables" from within ADO so that I can, in effect, perform
a single query based on tables from multiple databases/connections. Is this
possible? If so, how?

Thanks in Advance,

Shawn.

Relevant Pages

  • Re: Is DAO still being used for MS Access 2003
    ... rewrite thier application in ADO. ... , and most of the Access books in print still don't get ... I get a lot of my information from these newsgroups. ... Tony Toews, Microsoft Access MVP ...
    (microsoft.public.access.gettingstarted)
  • Re: mysterious lockup of form half-way through ADO code
    ... > Microsoft Access 2003 VBA Programmer's Reference ... >> It puts the current time plus 4 seconds in the field called BeginTime. ... the VB is the ADO version) ...
    (microsoft.public.access.formscoding)
  • Re: DAO to ADO
    ... Doug Steele, Microsoft Access MVP ... On Error GoTo ErrorOpenInitialisatie ... MsgBox "DAO OK" ... Yesterday I wrote the code (in ADO): ...
    (microsoft.public.access.setupconfig)
  • Re: Split database
    ... SQL command would work even in an Jet database but I don't recall any ... Yes, with ADO, I think it could look something like the following ... cn being a valid ADO connection, ... Tony Toews, Microsoft Access MVP ...
    (microsoft.public.access.tablesdbdesign)
  • Re: problem with msado20.tlb
    ... I think Val's point was that the current version of ADO is 2.8. ... Doug Steele, Microsoft Access MVP ... > Thank you very much Val Mazur, ... > What would you recomend for database programming using VB 6?. ...
    (microsoft.public.vb.database.ado)