[AccessD] How does Access locking work

John Bartow john at winhaven.net
Wed Sep 14 22:53:51 CDT 2011


IIRC you can open the .ldb file in a text editor and see the contents.

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of jwcolby
Sent: Wednesday, September 14, 2011 10:11 PM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] How does Access locking work

I am not really sure actually.  I find stuff about the lock file but only
what is actually in the lock file and that is just two pieces of info
(username / workstation I think).

I am talking about placing locks on records / pages, parts of the database
file etc.  How and where is that physically implemented.

John W. Colby
www.ColbyConsulting.com

On 9/14/2011 10:54 PM, Charlotte Foust wrote:
> Are you talking about the ldb file, John?  That was the lock file for Jet.
> That's reaching waaaay back but there's probably something in the
archives.
>
> Charlotte Foust
> On Wed, Sep 14, 2011 at 7:47 PM,
jwcolby<jwcolby at colbyconsulting.com>wrote:
>
>> I need to find documentation about the actual locking mechanism for
Access.
>>   I vaguely remember something about Jet using a file, and (IIRC) 
>> applying system locks to pieces out past the end of that file.  It is 
>> all very old memories and I am not finding anything "real" about the
actual details.
>>
>> Anyone know what it was I read so long ago?
>>
>> --
>> John W. Colby
>> www.ColbyConsulting.com
>>
>>
>> --
>> AccessD mailing list
>> AccessD at databaseadvisors.com
>> http://databaseadvisors.com/**mailman/listinfo/accessd<http://databas
>> eadvisors.com/mailman/listinfo/accessd>
>>
>>
>> Website: 
>> http://www.databaseadvisors.**com<http://www.databaseadvisors.com>
>>
>>
>>
--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com




More information about the AccessD mailing list