markofsoton
asked on
DoCmd.TransferDatabase, specify index in code
Hello,
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
Thanks
Mark
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
Thanks
Mark
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.