ADO Insert Queries Incomplete

[SMasterson]

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.

[devonknows]

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.

What references are you using, i mean personally i use the ActiveX Data 2.1 Library, then with that you create your SQL statement

SQLSTATEMENT = "SELECT * FROM MyTableName ORDER BY userID"

using the ADODB.Recordset

dim rs as ADODB.Recordset
 
rs = connectioname.Execute(SQLSTATEMENT, , AdCmdText)
 

all the records from MyTableName are now stored in the recordset (rs) which you can use a do while not rs.EOF loop to list it into your listbox or what ever you want to do with the data you are extracting.

Im not sure if this is what you are looking for but may just be a nudge in the right direction.

Kind Regards
Devon.