Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Search results for query: *
- Users: devSoft144
- Order by date
-
Close an ODBC connection
Thank you for the suggestion. I tried DoEvents and the same 3011 error occurred at the second TransferDatabase command. Evidently the second transfer collected the Oracle data. The problem seems to be creating the Access table. For some reason VBA cannot see the table collection. I...- devSoft144
- Post #3
- Forum: Microsoft: Access Other topics
-
Close an ODBC connection
I am importing data to Access 2002 from an Oracle database. My vba code is: Sub importTbl() DoCmd.TransferDatabase acImport, "ODBC", "ODBC;DSN=myDSN;UID=myUID;PWD=myPW", acTable, "SourceTbl", "DestTbl", False ' the above transfer is succesful. ' The next transfer produces an error...- devSoft144
- Thread
- Replies: 3
- Forum: Microsoft: Access Other topics
