This happens often. We have more t

[RoseV]

This happens often. We have more than 5 users at a given time in Access db. I'll get the error that "another user may have unexpectedly quit application while in use..." and that the db needs to be repaired. I'll kick everybody out and then repair. Sometimes it runs thru without a hitch. Sometimes I have to contact our help desk because when I try to repair, I get the message that it is locked by another user on another machine...our help desk tells me this is on a server level that it is locked up. I need to know A) why it needs to be repaired and B) how can I prevent it from locking up on the server level. We did have this problem alot less often when there were less users; altho it did happen. Is this the problem? Any ideas??

***Posted this before: any other ideas? We're
really stuck on this - it really was alot better when less people were using it.

 

[jebry]

Hi!

I don't know what solutions were provided previously but what you really need to do if you have not already is to split the Db and copy the FE to each individual user's computers. That way only one user is actually using each FE and this type of problem shouldn't crop up. Please note that I am talking about copying the actual front end to each user not just creating a shortcut.

hth


Jeff Bridgham
bridgham@purdue.edu