You could either create a query/view in your ODBC database, or link the tables as queries - such as (and yes, this is only linking another access file, you'll have to put your ODBC connection string in)
SELECT * FROM Table1 IN 'c:\OtherDB.mdb' WHERE ID=26;
Steven
There are 10 kinds of people in the world - those who understand binary - and those with friends
|