record locked in multiuser environment

[prodigy]

hi,
am trying to create an application for a company that has a small call-center (strength 20). the db is in the central server and each caller sits with frontend on their computer.
the central DB is shared on the network which these 20 PCs are accessing.

The frontend: 1 Form only which is based on a query that displays records.
Form Lock property: Edited Records
Query Property: Edited Records

As the telecaller starts calling the customer looking at the records, they are not able to edit certain records as the respective record is locked by MS-Access when am sure that no other telecaller has opened the particular record.

Any help is appreciated.

Prodigy.

 

[prodigy]

I can see that there are 82 viewers to this post but none turned to resolve the issue. Is my question so tough for you guys or you just dont have any time to attend. I have tried searching the forum with no good help. Can anyone plz help me out with this. Any help is appreciated.

 

[bonekrusher]

easy does it homie, give it some time and you will be helped. Have you tried searching the forum?

 

[The_Doc_Man]

There is a serious misconception about the "Edited Record" locking scheme. It doesn't mean that only the edited record is locked. What it REALLY means (in practical terms) is "Edited Record and any other record that happens to fall in the same 2K buffer"

Try the Help Files for "Pessimistic" vs. "Optimistic" locking. See if the parameter described in those topics makes matters better. I suspect you have "pessimistic" locking set when "optimistic" might be adequate.