[AccessD] Strange append query execution Access to Oracle ODBC

Benson, William (GE Global Research, consultant) Benson at ge.com
Mon Jul 30 23:32:17 CDT 2012


I have an accdb which in which oracle tables are linked using odbc. I was inserting into one of the oracle tables all the records from a local Access table. The query was taking a very long time, for under 10K records, about 10 columns. Strange thing was, I checked the oracle table using SQL Developer early on in the process and it seemed like the data was there lickety-split. I saw the full record count, and did check the actual data, which looked fine. Not sure if it was complete. I don't know how odbc works. I am confused what Access seemed to be waiting for, rather than announcing the query completed. The status bar was very slowly creeping from left to right.

At some point, I hit the Escape Key because I deemed it just wasn't worth the wait, and I figured I could export the access tables as text files, then import them into SQL Developer.

The strange thing is not only that all the records appeared to be in Oracle WAY before the query finished running, but after I hit Escape (which therefore meant I would not get a prompt about whether or not to allow the insert to be done, which one normally gets at the end of query execution), the data really did appear to be in Oracle, with no opportunity to cancel the insert.

Can anyone tell me what might be going on in this situation?

I have since deleted the data in Oracle because I just don't trust this process to have completed successfully.

Thanks



More information about the AccessD mailing list