ODBC tables

[k209310]

Is it possible to read a rcord in linked ODBC table and copy it accross in to a table in to access?

Does anyone know how would i even start going about this?

 

[mission2java_78]

Its a linked table...
so use vba to create a record in access and move that data over to an access table???

 

[RichMorrison]

Pat Hartman wrote
<<
I'm not sure why you would want to do this.
How are you planning on managing changes?
>>

I do this a lot for reporting applications with many "group by" reports *and* large-volume Oracle transaction data on a mainframe.

I copy the Oracle data to an Access table using ADO methods. Then the connection to the mainframe is closed. Just like using disconnected datasets in web apps.

All queries for reports can join the transaction data to other native Access tables when needed.

This design strategy has worked well for me.

Pat's second sentence is relevant if you need to update remote data. For reporting apps I don't.

RichM