I've been having more problems with a database I created for a client.  
They have been using it in a multi-user environment on a network.  After 
a few hours of successful use, it keeps crashing and suddenly begins 
giving various errors such as:

"Run time error 2001, you cancelled the previous operation."

...and...

"Module not found."

...and...

"Error 429, ActiveX component can't create object."

The only thing I can think of is something with record-locking settings.  
Has anyone experienced these problems before?  The database will work 
fine for hours and suddenly begin generating errors.  For the most part, 
these errors appear to occur while clicking buttons on the main menu.  
When we exit the database and go back in, the errors are still there.

I'd appeciate any help offered.  This is extremely frustrating as all our 
testing has worked fine until trying this in a multi-user environment.  
Is Access always this bad when trying to use it multi-user?

Matt

Have you split the database and placed a copy of the front end on each
user's machine? This doesn't sound like a record locking problem - more
like database corruption.

Splitting the database may not solve the problem completely, but may
show which user is causing the problem.

Brian


-----Original Message-----
From: Matt B. [mailto:admin@m...] 
Sent: 15 February 2003 01:06
To: Access
Subject: [access] Why does my multi-user database keep crashing after a
period of time?

I've been having more problems with a database I created for a client.  
They have been using it in a multi-user environment on a network.  After

a few hours of successful use, it keeps crashing and suddenly begins 
giving various errors such as:

"Run time error 2001, you cancelled the previous operation."

...and...

"Module not found."

...and...

"Error 429, ActiveX component can't create object."

The only thing I can think of is something with record-locking settings.

Has anyone experienced these problems before?  The database will work 
fine for hours and suddenly begin generating errors.  For the most part,

these errors appear to occur while clicking buttons on the main menu.  
When we exit the database and go back in, the errors are still there.

I'd appeciate any help offered.  This is extremely frustrating as all
our 
testing has worked fine until trying this in a multi-user environment.  
Is Access always this bad when trying to use it multi-user?