If I understand your question right, then yes, Access allows "linked tables"
but they're ODBC linked tables, so they get a different icon. When you
choose to link a table, under "type" choose ODBC database (should be at the
bottom of the filetype list) and then link to your DSN. Shout if you want
more info on making a user/system DSN (or want to know what one is).
Feel free to email me direct also.
Sorry if this got answered already, I'm on daily digest.
From: Nicholas Gledhill [mailto:nick@stripped]
Sent: 22 February 2006 04:30
To: MySQL ODBC List
Subject: MyODBC functionality
Noob question :-)
Does MyODBC allow "linked" tables from an Access database (running on a
Windows box) in a MySQL database (running on a Mac box, or Linux if
Director of IT
Digital Distribution Management (DDM)
Metropolitan Groove Merchants (MGM)
327 - 329 Pitt Street (Cnr of Bathurst)
Suite 18, Level 15
(02) 9283 8250
0419 60 90 25