I have an make table action query that takes 10 to 15 minutes to run and I would like to give the user some idea where they are in the process but for the life of me I can't figure out how. I know I can't create a recordset from an action query but is there some way I could keep track of the records as they are added to the table???
-
-
Welcome to Bytes, Mickey.
As far as I know it is not possible to do, however, if instead of using a query, you do the same thing using VBA, we can interface the VBA with a progress bar.
See the demo at
Phil -
Whoops! the link has vanished to the zip file.
Have re-linked it
PhilComment
-
The deeper question is what is the purpose of this make table query and what's the current SQL?
It's very rare that a make table query is "needed" and with some SQL tweaks, it may be possible to achieve a similar result in much less time.Comment
Comment