General information
Category:
Database DAO/RDO/ODBC/ADO
Title:
Recorcount command locks VB
HI,
I need to know the number of records that are stored into an Access table. The data is on a cd-rom and has something like 500 000 records. I use a progressbar to show the user the progress of the process. I need to know the Max value for the progress bar. For that, I use the AccessRst.RecordCount(Access Ado recordset previously created). My problem is that the PC is frozen for 15-20 minutes, the time it takes to VB to read the entire table. Usually, I would use doevents to regain the control of the PC but it is not possible with this case.
Can you help me ?
Thank you,
Christian Cote
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only