Re: Tools for record locking in MS Access

Ah, I could be wrong, but I thought JET has locked rows for some time now...

--
____________________________________
William (Bill) Vaughn
Author, Mentor, Consultant
Microsoft MVP
www.betav.com/blog/billva
www.betav.com
www.sqlreportingservices.net
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no rights.
__________________________________


"Daniel Crichton" <msnews@xxxxxxxxxxxxxxxxxx> wrote in message
news:u4KO4XrkFHA.1044@xxxxxxxxxxxxxxxxxxxxxxx
> 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