I'm using (thru Citrix) an access2K FE with SQL BE. My issue is I receive data from read only linked (ODBC) tables to a proprietary db. I need to run append & update queries to SQL (a different ODBC). So basically I need to do queries from 1 ODBC to a 2nd ODBC. Is there a way to do this without having to create tables in access as a half step solution?
Multiple platform ODBC query issue
- Thread starter gsc_81
- Start date
pdx_man
Just trying to help
- Local time
- Today, 07:40
- Joined
- Jan 23, 2001
- Messages
- 1,347
I think you answered you own question 
Create two DSNs to each datasource, link the tables in Access, create a query that updates data from the read-only DSN tables to the second DSN tables.
Perhaps I am not understanding something.
Create two DSNs to each datasource, link the tables in Access, create a query that updates data from the read-only DSN tables to the second DSN tables.
Perhaps I am not understanding something.
