background process?

[jmonty]

Hi again.
I have an Access 97 (VBA) application that loops through
several similar tables, removing duplicate records,
among other things.
Once started, the application uses 99% of the processor
and freezes my PC until it has completed. The screen won't
refresh and I can't do anything.
The process takes about 2 hours to complete.
Question:
Is there a way to assign my app a lower windows
system priority so that it doesn't monopolize my PC and I
can keep working on other things while it is running?
Is there a setting to make it into a background process or
have it run like a service or something?
(Now I don't just mean - Minimize the window)
This needs to run like an old mainframe batch-style
(COBOL, RPG) program.

Any suggestions?
TIA

 

[Arvin Meyer [MVP]]

Perhaps you should rethink how you're looping through the records. I just
build an SQL statement to hunt through 500,000 records to find duplicates in
a random record generation program that I'm working on. I found 20,000 dupes
in about 15 seconds on a Pentium 4 2.4 with 512 MB of RAM. Deleting them
took about 25 seconds more.
--

Arvin Meyer, MCP, MVP
Microsoft Access
Free Downloads
http://www.datastrat.com
http://www.mvps.org/access

 

[gandalf]

if you are looping with recordsets
you might try to add DoEvents in the loop
(gives control back to the system for a brief moment)