Hi, i'm importing oracle tables in Access using ODBC. Here's how I do it:
1. First I link the table in Oracle using ODBC
2. Run a make table query to copy the contents of the link table to my local table
3. Delete the link table
My problem is that if my table is big, this process do not work. It seems that the make table query runs before the table is successfully linked.
Does any one know how to check whether the table have been successfully linked before I run the make table query? Here's part of my code.
Set tdfStore= dbs.CreateTableDef("store")
tdfStore.Connect = strConnect
tdfStore.SourceTableName = "rms_owner.store"
Set tdfStore= Nothing
'If successful?? then run query
DoCmd.OpenQuery "qry_create_store", acViewNormal