DLookup a DAO Recordset

[MJPPaba]

Can anyone help me out.

I currently have a query against 2 tables of data taking about 30mins to query. Not efficient I can hear you say, not able to do anything about it unfortunately.

I need to extract one field from one record in a recordset of 33million records.

Attempts so far include:
Access Linked table and query table...Timeout failed
Access Passthough Query...Too long Failed
Create Dynamic Query with the criteria, apply a Dlookup formula to return the single cell value...Failed, Processing time too long.
Tried to put DAO Recordset (RST) into memory, but not sure about how to create a dlookup against an RST.

Any thoughts?


Cheese

Matt

 

[PHV]

Have a look at the FindFirst method and the NoMatch property of the DAO.Recordset object.

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886