To show progressbar, use ProgressBar ActiveX control (I hope you know how).
To get information about current status of the operation, use ADO asynchronous operations. Check MSDN topics "ADO Events", "Open Method (ADO Recordset)" - check adExecuteAsync, "FetchProgress (RecordsetEvent) Method (ADO)", "FetchComplete (RecordsetEvent) Method (ADO)".
Plamen Ivanov
MCSD .NET Early Achiever and MCAD .NET Charter Member (VB .NET/SQL Server 2000)
MCSD (VB 6.0/SQL Server 2000) br>
VB (.NET) - what other language do you need in the whole Universe?...