Re: Tools for record locking in MS Access

From: "Daniel Crichton" <msnews@xxxxxxxxxxxxxxxxxx>
Date: Wed, 27 Jul 2005 15:17:47 +0100

Swap wrote on Tue, 26 Jul 2005 22:47:03 -0700:

> Hi all,
> Is there any tool to achieve record-locking in MS-Access(2000).
> Thanks,
> Swapna.

Isn't the only way to do this to make sure that each record is in it's own
data page? Use padding fields (column that you never use with a long string
of spaces, for instance) to ensure that a record is always > 1Kb, and so
each record will never share a data page with another record. Not sure if it
works, but this is something suggested in a number of articles I've read.

Dan

.

Follow-Ups:
- Re: Tools for record locking in MS Access
  - From: William \(Bill\) Vaughn

References:
- Tools for record locking in MS Access
  - From: Swap

Prev by Date: Re: How can I tell what table a recordset is bound to?
Next by Date: RE: "Cannot create new connection because in manual or distributed tra
Previous by thread: Tools for record locking in MS Access
Next by thread: Re: Tools for record locking in MS Access
Index(es):
- Date
- Thread

Relevant Pages

Dan in Australia
... Here's a couple of articles about Dan while he's in Australia filming that ... Prev by Date: ...
(alt.fan.harry-potter)
Re: C# and Extended MAPI Sub Restriction
... > articles that also appear on the Microsoft site with information on ... Prev by Date: ...
(microsoft.public.win32.programmer.messaging)
Is MSLDBUSR.DLL be distributed with a retail app?
... I just want to know if MSLDBUSR.DLL be distributable with as retail ... Thanks & regards, ... swapna. ... Prev by Date: ...
(microsoft.public.data.ado)