Row level locking

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Scoop - 19 Jul 2007 18:25 GMT

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/microsoft.public.access/browse_thread/thread/ba15
4c6468e75bce/22320ff80db40099?lnk=gst&q=record+locking+subform&rnum=26#22320ff80
db40099

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)?

Reply to this Message

david@epsomdotcomdotau - 20 Jul 2007 00:17 GMT

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)

> 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
[quoted text clipped - 3 lines]
> I found the following post and KB article that seem like they would be
> worth trying:

http://groups.google.com/group/microsoft.public.access/browse_thread/thread/ba15
4c6468e75bce/22320ff80db40099?lnk=gst&q=record+locking+subform&rnum=26#22320ff80
db40099

> http://support.microsoft.com/?id=306435
>
[quoted text clipped - 3 lines]
> a way I could use this code to ensure that Row-level locking is
> throughout the database (i.e. in all forms)?

Reply to this Message