DoCmd.TransferDatabase, specify index in code
Posted on 2005-03-08
I am writing an access app for a disconnected view of an oracle database
i can handle importing tables no problem
DoCmd.TransferDatabase acImport, "ODBC", strOdbc, acTable, "SPATIAL.V_LITTERBIN", "SPATIAL_LITTERBIN"
but this 'table' runs off a view so the index BIN_ID needs defining in the local db.
anyone got a bit of code that will define the index once the table is imported
also can you replace tables without having to delete the original. ath the moment it will just import the table and add a number to the end if the object already exists