Gregg
greggs at msn.com
Wed Feb 18 08:35:44 CST 2004
You're right! I did change it to a record set and got some speed back. But the fact that my second copy spends 4 times as much time as my first copy makes me think something is set up wrong, and maybe EVERYTHING is slower than it should be. -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com]On Behalf Of Lonnie Johnson Sent: Wednesday, February 18, 2004 7:33 AM To: Access Developers discussion and problem solving Subject: Re: [AccessD] Stumped on A97 Speed Problem Are you using the aggregate function dlookup? Those things can be very slow. You may want to look at getting values from a recordset object. Just a thought. Lonnie Johnson ProDev, Professional Development of MS Access Databases Visit me at ==> http://www.prodev.us --------------------------------- Do you Yahoo!? Yahoo! Mail SpamGuard - Read only the mail you want. _______________________________________________ AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com