Hi all, I am trying to execute code to insert records from an Access 2002 Xtab query to a remote Sql_Server table. I keep getting a random problem where the Access query doesn't complete before the Sql_Server insert begins. I have tried locks, state checking and indexing. It is almost like the code is running too fast for the process to be completed. In the example below, I get the same null result repeatedly for one field in one record.
...
SMasterson
Last Activity: Mar 13 '08, 10:42 PM
Joined: Mar 17 '07
Location:
-
Query doesn't finish executing
-
ADO Insert Queries Incomplete
I frequently use ADO objects in VB6 with MS Access "Append" queries. I repeatedly have problems with the queries completing without all of the expected records. If I put a break in the code right after the action query the query will complete as expected. Am I missing a setting or flag that will allow for the full completion of the update?
Thanks. -
Problem With Vb6 Pdw
Some of the files that I add to my PDW package are missing part of the source path name in the wizard window. When the packager starts I get the message "Error 76 Path not Found". Does anyone know how to correct to the full source path name?
No activity results to display