Re: Tools for record locking in MS Access



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


.



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)