Persistent locking ldb file

[Lars Brownie]

In http://www.granite.ab.ca/access/performanceldblocking.htm I read about
persistant locking the ldb file.

Does this apply for Access 2003 and 2007 as well?
Is this a feature that one should build in a multiuser mdb by default or is
this not necessary?

Thanks, Lars

 

[Klatuu]

It not absolutely necessary with a small number of users, but with any number
of users, it does improve performance and it provides a vehicle for other
useful functionality. For example, lets say you need a way to boot off the
user who went home and left her copy of the front end open and you need to do
some maintenance on the back end database. You can add a timer event to the
invisible form that periodically checks the value of a field and if a certain
value is found, Quit the application. You can also use the same concept to
send messages to users, like "System will be taken down in 10 minutes", and
such.

It is also useful for global information. You can put a value in control on
the form and reference it from other locations in the application.

 

[Lars Brownie]

Thanks!

It not absolutely necessary with a small number of users, but with any
number
of users, it does improve performance and it provides a vehicle for other
useful functionality. For example, lets say you need a way to boot off
the
user who went home and left her copy of the front end open and you need to
do
some maintenance on the back end database. You can add a timer event to
the
invisible form that periodically checks the value of a field and if a
certain
value is found, Quit the application. You can also use the same concept
to
send messages to users, like "System will be taken down in 10 minutes",
and
such.

It is also useful for global information. You can put a value in control
on
the form and reference it from other locations in the application.

 

[Tony Toews [MVP]]

It not absolutely necessary with a small number of users, but with any number
of users,

When a small number of uses is more than 1 then the record locking
technique is required for performance.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/