468,457 Members | 1,779 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 468,457 developers. It's quick & easy.

Row-level locking Q. Front-end? Backend? Both?

(I've tried this Q in the ms forums without response. See how it goes
here.)

Using A2003 but I guess this is not version-specific...

If I want to implement row/record level locking on a split database where
do I need to set this option. Is it sufficient to set it in the frontend
database for record-level locking to apply to the backend tables. Or must
I also set it in the backend mdb database instead or as well (which is
never 'opened' in an Access sense.

To take this further, what about a situation where some backend tables are
being shared between different frontend applications. Let's say there are
two applications, one requires record level locking and the other doesn't
and both apps are set 'correctly' for their own operation.
How does it work then because there is only one ldb file per backend?

(I'm leaving this Q as mdb-specific because that is my immediate interest
but obviously it could be continued
further)

Enlightenment welcomed.

Peter
Nov 13 '05 #1
2 2844
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

From the Access Help article "RecordLocks Property" it appears that the
lock type only applies to the front-end. IOW, when the front-end
accesses the data it applies the indicated lock type; another front-end
would apply it's own lock type.

For the record :-) Access doesn't have true row (record) locking - it
has page locking. One page is 4Kbytes. Depending on the size of the
record, a page may contain more than one record.
--
MGFoster:::mgf00 <at> earthlink <decimal-point> net
Oakland, CA (USA)

-----BEGIN PGP SIGNATURE-----
Version: PGP for Personal Privacy 5.0
Charset: noconv

iQA/AwUBQm1pHYechKqOuFEgEQKldACcCtyIb8n2neIZ8UnXVEm/ohYqVC0AoOOq
CXMbis8h+8hata6kHH15W4Cg
=z7QJ
-----END PGP SIGNATURE-----
Peter wrote:
(I've tried this Q in the ms forums without response. See how it goes
here.)

Using A2003 but I guess this is not version-specific...

If I want to implement row/record level locking on a split database where
do I need to set this option. Is it sufficient to set it in the frontend
database for record-level locking to apply to the backend tables. Or must
I also set it in the backend mdb database instead or as well (which is
never 'opened' in an Access sense.

To take this further, what about a situation where some backend tables are
being shared between different frontend applications. Let's say there are
two applications, one requires record level locking and the other doesn't
and both apps are set 'correctly' for their own operation.
How does it work then because there is only one ldb file per backend?

(I'm leaving this Q as mdb-specific because that is my immediate interest
but obviously it could be continued
further)

Nov 13 '05 #2
Bri

MGFoster wrote:
For the record :-) Access doesn't have true row (record) locking - it
has page locking. One page is 4Kbytes. Depending on the size of the
record, a page may contain more than one record.


True for AC97 and earlier, optional for AC2K on.

--
Bri

Nov 13 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

8 posts views Thread by Jason | last post: by
7 posts views Thread by Micha? | last post: by
2 posts views Thread by Chris Plowman | last post: by
2 posts views Thread by michael sorens | last post: by
6 posts views Thread by Miro | last post: by
1 post views Thread by subhajit12345 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.