dlookup

[qwertyjjj]

Do the Access functions dlookup, etc. cause performance issues when using remote SQL servers where the data is held?

 

[mhartman]

Hello:

There is a performance hit when using aggregate functions in Access. So I would imagine it would be compounded over a network.

http://www.thescripts.com/forum/thread533318.html

is a link to an alternate approach

Regards
Mark

 

[qwertyjjj]

So, better to create a SQL query than scan an entire table with DLookup ?

Ideally, if you could bring all data back in 1 recordset then that would be even more efficient ?