Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
IS DLOOKUP SLOWER IN ACCESS 2000?
- Thread starter dkaplan
- Start date
I had a similar performance issue shortly after converting my Access 97 database to 2000. After a couple of re-compiles, the performance issues, broader than the Dlookup one, went away. WEIRD!
You could try that. Otherwise, on a technical level, I don't know.
Gary
gwinn7
You could try that. Otherwise, on a technical level, I don't know.
Gary
gwinn7
JerryDennison
IS-IT--Management
It's a function of "bloat" that is inherent in A2k and the overall slow processing of domain aggregate functions in general. Domain aggregate functions are notoriously inefficient methods in Access. So much so, that there have been other domain aggregate functions written by other people for this very reason.
- Status
Similar threads
- Locked
- Question
- Locked
- Question