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.

No. You would have to do this via an asynchronous query, and DAO supports those
only in ODBCDirect workspaces.

~~~~~~~~~~~~~~~~~~~~~~~~~~~
Please post/reply to the newsgroup(s) so
that everyone can benefit from the discussion.

Regards,

Klaus H. Probst, MCP


       ICQ: 22454937
      The VB Box: http://members.xoom.com/kprobst/
~~~~~~~~~~~~~~~~~~~~~~~~~~~