Window Explorer Hangs while Access 97 Running Queries

J

Jacob Golden

Mostly when I'm running VB code that uses pass-through queries to pull in
data and commit it to a table in chunks (but sometimes when just running
internal queries) Access seems to hang my Explorer.exe until it is finished.
I can't use my application bar, Start, or use any programs that aren't
already open. I can Alt-Tab to an already open application but can't really
use it. Anyone have an idea of how to fix this? Is it a memory or resource
issue?
 
Top