[AccessD] rsR("order") vs rsR!Order

Oh. I am not much good at  reading others' code. Thanks for clarifying.

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Stuart McLachlan
Sent: Monday, August 01, 2011 9:45 PM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] rsR("order") vs rsR!Order

No, I didn't do anythiing with the tables since:
1. There was only one record in each table
2. I didn't actually update the table, I just repeatedly moved data from one
recordset buffer to 
the other.

On 1 Aug 2011 at 21:38, William Benson (VBACreations. wrote:

> Nice Test Stuart,... Did you delete table and compact in between
> tests? I still think the time adding records to a table and updating
> the recordset is needless expansion on the time test. The real issue
> is simple reference, and I think that the fastest test for this may be
> just a string assignment (or a debug.print - I opted for the former).


-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com