Best VB method to cycle through records in a table

  • Thread starter Thread starter HCS
  • Start date Start date
H

HCS

Hello,

I know a number of methods to go through the data within a table using VB.
What is the general feeling as to which is the best way. is it using
querydefs?

Cheers
 
You should be using a Recordset. Whether you use a string containing the SQL
or a querydef as the basis for the recordset shouldn't really matter that
much.
 
Hello,

I know a number of methods to go through the data within a table using VB.
What is the general feeling as to which is the best way. is it using
querydefs?
Click to expand...

The best way is to not "cycle through records in a table" at all if
you can avoid it; running an action Query will usually be more
efficient than bringing up each record and (say) editing it.

If you do need to step through records, just create a Table type
Recordset (or a Snapshot if you want read-only access).

John W. Vinson[MVP]
Join the online Access Chats
Tuesday 11am EDT - Thursday 3:30pm EDT
http://community.compuserve.com/msdevapps
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Cycle Through Records in a Table using VBA 2
Cycle through records to find a value 3
Cycling through records 1
Parsing a table 1
Points for placings - best method 3
VB Access Table creation from a SQL Pass-Through Query 2
Access Click in Table to Open Form 0
Append Access Data to SQL Server Table 12

Back
Top