[AccessD] Page Locking Happening - But Set to Record Locking

William Hindman wdhindman at dejpolsystems.com
Thu Mar 5 21:42:11 CST 2009


...afaik, A2k3 dao uses page level locking only unless it is first set from 
ado ...if you know of any way to make it play otherwise I'd love to hear it.

William

--------------------------------------------------
From: "Dan Waters" <dwaters at usinternet.com>
Sent: Thursday, March 05, 2009 9:34 PM
To: "'Access Developers discussion and problem solving'" 
<accessd at databaseadvisors.com>
Subject: Re: [AccessD] Page Locking Happening - But Set to Record Locking

> Wow!  That's a head-turner!
>
> I do have to say that I haven't seen this behavior in Access 2002 or 2003.
> So perhaps they did fix it in those versions.  But this client uses Access
> 2000.
>
> And yes - if you can give me a lead to the KB article I will be in your
> debt!  I don't know how but it's a good sentiment!  :-)
>
> Thanks!
> Dan
>
> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com
> [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Jim Dettman
> Sent: Thursday, March 05, 2009 6:58 PM
> To: 'Access Developers discussion and problem solving'
> Subject: Re: [AccessD] Page Locking Happening - But Set to Record Locking
>
> Dan,
>
>  Even though you are set for "record level" locking, not all operations 
> are
> done at that level.  Index updates, memo pages, DML operations, etc. are
> always done at page level.
>
>  Also the first user in must be set for record level locking otherwise
> everyone defaults to page level regardless of setting.
>
>  There is also a bug where DAO in code will not record level lock unless
> you first open a recordset in ADO.  There is a MSKB article on that which 
> I
> can dig out if you want.
>
> Jim.
>
> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com
> [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Dan Waters
> Sent: Thursday, March 05, 2009 6:11 PM
> To: 'Access Developers discussion and problem solving'
> Subject: [AccessD] Page Locking Happening - But Set to Record Locking
>
> Twice now I've seen what appears to be page locking in the BE mdb when 
> that
> file is set to record locking.  About 8 contiguous records show locking -
> reminds me of Access 97, but they are using Access 2000.
>
> Has anyone seen this before or know of a fix?
>
> Thanks!
> Dan
>
>
>
>
>
> -- 
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>
> -- 
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: 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