Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium


DoCmd.TransferDatabase,  specify index in code

Posted on 2005-03-08
Medium Priority
Last Modified: 2012-06-27

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



Question by:markofsoton
LVL 26

Accepted Solution

dannywareham earned 280 total points
ID: 13486019
LVL 51

Assisted Solution

by:Steve Bink
Steve Bink earned 220 total points
ID: 13486562
>>> also can you replace tables without having to delete the original.

No.  You can delete all the records from the original (thus leaving the structure intact) and replace them with new records, but otherwise you must DROP the table and recreate it.

Featured Post

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Code that checks the QuickBooks schema table for non-updateable fields and then disables those controls on a form so users don't try to update them.
Windows Explorer lets you open cabinet (cab) files like any other folder. In VBA you can easily handle normal files and folders, but opening and indeed creating cabinet files takes a lot more - and that's you'll find here.
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…
Look below the covers at a subform control , and the form that is inside it. Explore properties and see how easy it is to aggregate, get statistics, and synchronize results for your data. A Microsoft Access subform is used to show relevant calcul…

571 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question