Multi User: Record lock while accessing same table

[DeCiDeR]

We have FE copies on users desktop which links to tables on the server
database. The form is pointing to a table and multiple users are
running that same form at same time. The access database is 2003
format. When one person is adding a record in that table, and another
person tries to add new record, it says table is currently locked by
first user. There are three users most of time is same table all day
long. How can i fix it. I already checked the NO Lock under options,
advanced and open with record level locking is also checked. I also
checked the properties for the form and that also have no lock and
dynaset. How to fix this problem. The table itself is having 50000
records and it keeps increasing every day.

I need to make it such a way that multiple user can access same table
and input their records with getting locked out message.

 

[Tom Wickerath]

Hi DeCiDeR,

Does the table include one or more memo data type fields? Take a look at
this KB article:

http://support.microsoft.com/?id=275561

Click on the link at the beginning that reads "Record-level locking". In
this section, you will find the following:

"A limitation to record-level locking is that users will not be notified
when another user is locking the record. Also, record-level locking is not
enabled for Memo data types."

I'm not positive, but I think the same limitation would apply to hyperlink
and OLE Object data type fields as well, since these share the pointer
mechanism with memo data types.

Also, you should know that when you select the option to use record level
locking, under Tools > Options, this is just a request, not a demand. To
ensure that the first person who opens the database opens it with record
level locking enabled, you might want to implement the procedure shown in
this KB article:

PRB: Jet 4.0 Row-Level Locking Is Not Available with DAO 3.60
http://support.microsoft.com/?id=306435


One final link, since I'm offering all kinds of links <smile>

Implementing a Successful Multiuser Access/JET Application
http://www.access.qbuilt.com/html/multiuser_applications.html


Tom Wickerath
Microsoft Access MVP

http://www.access.qbuilt.com/html/expert_contributors.html
http://www.access.qbuilt.com/html/search.html
__________________________________________