Split Database locking

paindivine

Registered User.
Local time
Today, 08:13
Joined
Dec 13, 2006
Messages
23
I have a call tracking database with 5 active users. Ocasionally the database will freeze, usually for several people at once. It will say:
"Can not update record; Currently Locked"

The only way to fix it is to close and re-open. I split the database, compiled it and then created an MDE file to distribute. They are using copies of the front-end, not links. The database locking more and more every day. But we are using it more. After parusing the forum I'm starting to suspect that this is a problem of "Primary Key duplication" If everyone trys to create a record at the same time, would the database lock because we all created the same record at the same time?

If so, how do I get around this? Use something other than Autonumber for the primary key? Or is this an entirely different problem?

By the way, my record locks are set to "No Locks"

Thanks!
 
Last edited:
Not sure if this is any help to you but I encountered a similar problem when I worked in an office with several people using the same database. In our case the problem seemed to come about whenever somebody left their curser within a combo box, which would 'lock' the field and prevent anyone else from updating. The problem would be resolved as soon as the person clicked out of the box.

Hope you manage to get it sorted!
 
Hi All,

I have a problem exatcly corresponding to the one described by the user who started this thread. I did search this and other forums for a solution, but the only one I can think of so far is a kick off procedure to logout all front-end users. Any other suggestions, please?
 

Users who are viewing this thread

Back
Top Bottom