Simply create a linked table then use it like any other table.
Alternatively, create a pass-through query.
Change your SQL to Select MyField From MyTable (i.e.: what you have already,
without the in "ODBC;..." part) Instead, select SQL Specific from the Query
menu, and choose the Pass-Through option. In the Query properties window,
you should see a property labelled "ODBC Connect Str". Pasted what you hadReference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=13114
before in your "ODBC;..." string into that property.
Doug Steele, Microsoft Access MVP http://I.Am/DougSteele
(no e-mails, please!) wrote in message
> >From what I've seen in other posts, it looks like I should be able to
> run a query through Jet SQL that does something like
> select MyField from MyTable in "ODBC;DSN=MyDSN;UID=;PWD="
> When I do this, it tells me that it can't find the file
> "c:\ODBC;DSN=MyDSN;UID=;PWD=". Is there a way to directly query
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=13114
> another database via ODBC just used Jet SQL?