Automation of a Process: Impoprting a OBDC table into Access

[riggo44]

Hi,

I have built a process that contains several tables, hierarchy based look-up tables, that are linked with an OBDC driver. When running queries against these linked tables I am experiencing a performance issue. I have found that if I import these OBDC based tables into my DB the performance of the queries increase 10 fold. Is there a VB Code or MacroCommand out in Access that will go out to a OBDC maintained table and automatically import a table.

The only other option I have found is to each time I run the process that I re-import the OBDC based tables, manually, to ensure that I have the most recent changes to the hierarchy based table I am importing.

 

[PHV]

Another way is to use PassThru queries.

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[genomon]

Why can't you link then into the mdb since they are ODBC-compliant?

The early bird may get the worm, but the second mouse gets the cheese in the trap.