Jim Dettman
jimdettman at verizon.net
Fri Jan 15 07:35:26 CST 2010
Rocky, If findfirst is too slow, open it as a table and use .Seek That is the fastest way to search a JET table. Jim. -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Rocky Smolin Sent: Thursday, January 14, 2010 6:56 PM To: 'Access Developers discussion and problem solving' Subject: Re: [AccessD] Fastest Way That was my first thought - brute force - time is not that critical. And it would only be a couple of lines of code additional in the current import routine - just a .FindFirst. If later it turns out that the time is unacceptable, I could bail to the other approach. Still thinking.... But with the brute force method I could quickly set up a test case. I already put start time, end time, and elapsed time test boxes on the form. Rocky -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Max Wanadoo Sent: Thursday, January 14, 2010 1:36 PM To: 'Access Developers discussion and problem solving' Subject: Re: [AccessD] Fastest Way It's a done deal. If you want speed and efficiency, then go my way. Unique index on relevant fields. Let access handle the dupes. One read-One input-Finito. Max -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Heenan, Lambert Sent: 14 January 2010 21:22 To: 'Access Developers discussion and problem solving' Subject: Re: [AccessD] Fastest Way I think we'd all be interested to know what method you eventually use, and how the performance is. Lambert -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Rocky Smolin Sent: Thursday, January 14, 2010 1:33 PM To: 'Access Developers discussion and problem solving' Subject: Re: [AccessD] Fastest Way Actually don't want to delete and import - just bypass the incoming records that are already in the table. R -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com