Re: multi-level table linking

That's the answer I was expecting. The far back end (Sybase, MySQL, & MS
SQL) tables are currently linked directly to the front end. There are also
active Access tables derived from the far back end tables there. So,
everything is sitting in the same MDB I was hoping to separate the front
end from data tables, same as a traditional splitting of a single MDB, thus
easing my application maintenance and maybe lessening network traffic. Oh
well...

Thanks.
John G.

"Roger Carlson" <NO-Roger.J.Carlson-SPAM@xxxxxxxxx> wrote in message
news:eEWi5Jf$GHA.4992@xxxxxxxxxxxxxxxxxxxxxxx
You cannot link linked tables. Why can't you link them directly to the
Front
End?

--
--Roger Carlson
MS Access MVP
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/wa.exe?SUBED1=ACCESS-L


"John Goodfellow" <nospam@xxxxxxxxxxxxx> wrote in message
news:eKOn7Cf$GHA.3604@xxxxxxxxxxxxxxxxxxxxxxx
I would like to link tables from disparate databases from different
servers
(MySQL, Sybase, & MS-SQL) into an Access 2003 database back end located
on
another server, then link those tables in the back end MDB to a front end
MDB on the client machine.

When I attempt this using ODBC System DSN's to the source DB's, the
source
tables link into the middle MDB fine, but the "Get External Data" dialog
on
the front end client MDB does not offer those tables for selection.

Anyone know of a technique to accomplish multi-step table linking in
Access?
Or am I completely delusional?

Thanks.
John G.






.

Relevant Pages

  • Re: how do you burn cd of old database
    ... Thank you for the help John. ... and the "Hide extensions for known file types" was already unchecked. ... Find the mdb file's icon and drag ...
    (microsoft.public.access.externaldata)
  • Re: Who has locked the mdb
    ... can used Windows file share utilities to show which computers have the ... If so, split the database into a front end, back end, ... In this case we had to make sure on one was in the mdb because of several ...
    (comp.databases.ms-access)
  • Re: Migration and authorisations
    ... John wrote: ... We have one mdb and an associated mdw that now gives us trouble. ... If the users try to open the mdb they get the message: ... You did not mention the database and version or anything like that so you are probably not going to get much usable help. ...
    (comp.databases.ms-access)
  • Re: How to capture last used date/time
    ... On Aug 20, 6:08 pm, John W. Vinson ... reminds me, did you say in another thread you have a technique for ... ensuring the mdb is only accessed via one application? ...
    (microsoft.public.access.gettingstarted)
  • Re: Importing dbf files from Microsoft Works
    ... MDB is open. ... You may not need any additional drivers. ... GET EXTERNAL DATA but it is greyed out. ... > I can import this dbf file into Access? ...
    (microsoft.public.access.externaldata)