View running Query Details

[jeffwest2]

I have a an Access 2007 program that imports in some data, then runs a query to check for duplicates and removes the new records where duplicates exists, the issue is this runs really slowly.

I have tried to change this to VBA SQL, but it runs just as slowly, so, my next idea was to try and create on a form a text box that is showing which record it is currently working on to show the userthat it is actually doing something, my issue here is that I cannot seem to work out a way of returning to the text box the record being worked on from the query.

My other thought was to run a query or VBA sql that first counts the number of records to be deleted, then runs the delete query against those records and so a real time progress meter could show
A) the count taking place
B) The deletion taking place with the count as 100%.

but hereI could only seem to create a progress bar with a pre-determined maximum.

Any help with this would be appreciated

Didn't anyone ever tell you? There's one thing you never put in a trap — if you're smart, if you value your continued existence, if you have any plans about seeing tomorrow — there's one thing you never — ever, put in a trap. … Me.

 

[jeffwest2]

Thanks for anyone that looked at this, I have done it another way which is running a lot better.

Didn't anyone ever tell you? There's one thing you never put in a trap — if you're smart, if you value your continued existence, if you have any plans about seeing tomorrow — there's one thing you never — ever, put in a trap. … Me.