Jack and Pat
drawbridgej at sympatico.ca
Sat May 31 10:30:34 CDT 2008
John, I did some searching to see if I could find anything relevant. I did find this M$oft reference for what it's worth. http://msdn.microsoft.com/en-us/library/aa189633(office.10).aspx Jack -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of jwcolby Sent: Friday, May 30, 2008 2:29 PM To: Access Developers discussion and problem solving Subject: Re: [AccessD] Been Dazed and Confused for so long it's not true. > If you're setting locks in ADO and editing the table in DAO, you will find differences. LOL. Now wouldn't THAT be cute. A lock is a lock except when... At the moment I am setting locks by editing in DAO and then trying to count the locks using DAO. That isn't working. The DAO recordset coming along behind to test the locks is not finding any locked records. This whole subject is looking very messy. Hey, does anyone think we should just ignore unnecessary stuff like locks and release a brand new version called 2007? Or perhaps 2007 fixed this? ROTFLMAOBTC BWAAAAHAAAAAHAAAA John W. Colby www.ColbyConsulting.com Charlotte Foust wrote: > John, > > If you're setting locks in ADO and editing the table in DAO, you will > find differences. I ran into that a long time ago, but I've forgotten > the details. I think that's why I was always so careful to limit myself > to working in one model or the other at a time. > > Charlotte Foust -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com