>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.

Use a «SELECT COUNT(*)» to retreive the number of records.