Max Wanadoo
max.wanadoo at gmail.com
Sun Aug 9 11:05:05 CDT 2009
Well, I only mentioned it in the hope of making you jealous lol Max -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of jwcolby Sent: 09 August 2009 13:19 To: Access Developers discussion and problem solving Subject: Re: [AccessD] OpenRecordSet question > FWIW my results hover around the 150 mark ?? DBENGINE is 1. Yep, and the amount of time obviously increases as the db gets larger, but also of course varies by speed of the machine. John W. Colby www.ColbyConsulting.com Max Wanadoo wrote: > Very interesting John, > > FWIW my results hover around the 150 mark ?? DBENGINE is 1. > > So, clearly the answer is to Set db = DBEngine(0)(0). That way you will > know that you ARE actually looking at the DB as it exists and not as it DID > exist at the time when the object was created. > > Thanks for the effort. > > Max > > -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com