Multiple Instance of Access - slow to run

M

Mark

All,

I'm using Access 2000 and, when I'm running a long query, it slows down any
other access database I have. It doesn't slow down all programs, actually,
just MS Office programs, it seems.

Is there a way to modify Access so that doesn't happen? I'd like to have the
ability to run a lengthy query on one DB, while making updates to another.

Thanks,
-Mark
 
J

Jason

I doubt it... Your using up system resources and Access is a memory hog to
begin with.
 
M

Mark

Hi Jason,

I think it's more than that (but maybe I'm wrong). While I'm running a
query, I can do other things like surf the web, check email, etc. Just runs
slower. But if I try to launch an Access db, it's almost as if the launched
db "waits" until the query is finished.

If it were simply a system resource issue, i'd expect everything to run
slower, not just other Access dbs.

-Mark
 
D

Dr. Know

Mark said:
All,

I'm using Access 2000 and, when I'm running a long query, it slows down any
other access database I have. It doesn't slow down all programs, actually,
just MS Office programs, it seems.

Is there a way to modify Access so that doesn't happen? I'd like to have the
ability to run a lengthy query on one DB, while making updates to another.
Click to expand...

I could be wrong, but Jet (the db engine for Access) is not exactly
the most efficient multi-threaded engine out there. I fact, I would
avoid this type of usage - but that's me. Corruption of DB's is
already somewhat of a problem.
FWIW,


Dr. Know
 
Top