Form Locking

[SteveE]

I have a DB which I have an irriating problem with. I have one user who locks the DB I cannot find any setting to be different on his machine but, when another user is adding records and has completed the system reports back that it cannot save the record. If I take the offending user machine and close the record he is working on it then releases the locked one (It is not the same record autonumber)
any advise welcome
Steve

 

[Travis]

What version of Access is the Database In?

What version of Access are the users using?

Have you structured the database so that it has a Front End (FE) and Back End (BE)?

Does each user have their own copy of the Front End or are they all accessing the Same File?

Have you noticed any other combiniations of users that also seems to lock a record?

 

[SteveE]

Locked Record

All on access 2000,
It is a FE / BE but the FE resides on the server and is accessed only by 3 - 4 users at any one time,
There are no other combinations that have the same problem as I am aware.

Steve

 

[Mile-O]

The Front End is on the server? Surely it should be the Back End that's on the server.

 

[SteveE]

File Lock

The FE and the BE are both on the server and user access the FE via a shortcut.

 

[Mile-O]

They should have a Front End each - not a shortcut to one.

 

[Kevin_S]

Search for "Record Locking" and "Lock Optimistic", "Lock Pessimistic " in the forum and you should find answers to your locking problem...

Its probably stemming from the fact that you have multiple users accessing the FE on the server - Try rolling out the FE to each user's machine and then relink the BE's to the DB on the server. This way each user has his/her own FE which should remove your problem...

HTH,
Kevin