[AccessD] DLookup vs FindFirst

[Rocky Smolin]

Thanks.  Seek is the fastest.  Haven't used it for years, though.

Best,

Rocky
 

-----Original Message-----
From: AccessD [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of
John Bodin
Sent: Tuesday, May 24, 2016 10:26 AM
To: 'Access Developers discussion and problem solving'
Subject: Re: [AccessD] DLookup vs FindFirst

Rocky, assuming the table you need to do the lookup in is a Linked Access
table, I would open the table using the below code (there are multiple
variants out there on the web) which will allow you to use the lightning
fast Seek method.   You will need an index in the related table on what you
are Seeking on.   Much faster than either method you mention. 

http://access.mvps.org/access/tables/tbl0006.htm


John

John Bodin
sBOR Office Systems
jbodin at sbor.com


________________________________________
From: AccessD <accessd-bounces at databaseadvisors.com> on behalf of Rocky
Smolin <rockysmolin at bchacc.com>
Sent: Tuesday, May 24, 2016 1:04 PM
To: 'Access Developers discussion and problem solving'
Subject: [AccessD] DLookup vs FindFirst

Dear List:

Importing a csv file 50k-100k rows.  I have to get an PK from a related
table.  Which would be faster - DLookup or FindFirst in a DAO recordset?

MTIA

Rocky

--
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