William Hindman
wdhindman at dejpolsystems.com
Thu Mar 5 19:59:29 CST 2009
...its not exactly a bug ...when MS did the jet 4 update they added record level locking and updated ado at the same time to use it ,,,but there has been no update to dao ...so you have to open the db with ado setting record level locking in jet and then revert to dao ...that's very old news ...keep hoping there will be an update to dao now that Access is back in that camp and no longer hog-tied by the ado gurus in the SQL Server brigade :( William -------------------------------------------------- From: "jwcolby" <jwcolby at colbyconsulting.com> Sent: Thursday, March 05, 2009 8:21 PM To: "Access Developers discussion and problem solving" <accessd at databaseadvisors.com> Subject: Re: [AccessD] Page Locking Happening - But Set to Record Locking > > 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. > > Wow. That is the first I have ever heard of that one. The things you > learn on this list. > > John W. Colby > www.ColbyConsulting.com > > > Jim Dettman wrote: >> 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 >