Row level locking

[Scoop]

I have a 2003 DB that is a decent size ~350MB in a FE/BE
configuration. There are 5 or so users in the database at any given
time and I occasionally get record locking errors that don't seem to
make sense.

I found the following post and KB article that seem like they would be
worth trying:

http://groups.google.com/group/micr...cord+locking+subform&rnum=26#22320ff80db40099

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

Has anyone else experienced this?

Also, the code in the KB article is used for a specific form. Is there
a way I could use this code to ensure that Row-level locking is
throughout the database (i.e. in all forms)?

 

[Guest]

All of the examples are for Database locking mode.
The kb article demonstrate using Database locking
mode while accessing a table, but it is the whole database
that is page mode or row mode.

Database locking mode is only a hint. If the database
is already open in row mode or page mode, it stays
that way. A database can only be either in row mode
or page mode, because there is only one set of lock
user records for each database.

(david)