By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
455,097 Members | 1,405 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 455,097 IT Pros & Developers. It's quick & easy.

ADO Insert Queries Incomplete

P: 3
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.
Mar 27 '07 #1
Share this Question
Share on Google+
1 Reply


devonknows
100+
P: 137
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
Expand|Select|Wrap|Line Numbers
  1. dim rs as ADODB.Recordset
  2.  
  3. rs = connectioname.Execute(SQLSTATEMENT, , AdCmdText)
  4.  
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.
Mar 27 '07 #2

Post your reply

Sign in to post your reply or Sign up for a free account.