Information générale
Catégorie:
Bases de données DAO/RDO/ODBC/ADO
Titre:
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
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement