
Progress of an executing SELECT statement?
Hi,
I'm using the .Execute method to run a SELECT statement in my program.
The SELECT takes records from my Access database and puts them into
another datasource, eg. (takes data from source biblio.mdb and puts it
into an Excel spreadheet)
Dim MyDb As Database
Set MyDb = Workspaces(0).OpenDatabase("c:\temp\biblio.mdb")
MyDb.Execute "SELECT * INTO _
[Excel 5.0;DATABASE=C:\temp\].[test4.xls] FROM [authors]"
The user doesn't know this is happening, and I have no control over how
large the source data table will be, so this SELECT could take some
time.
I want to give the user some feedback to let them know how long the
process will take, eg. a progress bar - can I find out the progress of
my SELECT, while it is running?
Many thanks in advance,
Andy Bibby.
----
Programmer, ADG Computer Systems Ltd, Oxford, UK.