[AccessD] DLookup vs FindFirst

[John Bodin]

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