Slow query with user-defined functions

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I've got a query with a couple of user-defined functions in it (one with some
DAO code). It was quite slow in Access 97 but is now painfully slow in 2003.
From scanning the newsgroup I see there were some similar problems with
early service packs of Jet 4 in Access 2000 but I've got SP8 - actually
MS04-014.

Any ideas gratefully received...
 
Unfortunately, JET 4 is *way* slower than 3.5 when you have user-defined VBA
function calls in your query.

AFAIK, there is nothing you can do about it other than avoid the function
calls.
 
Could the query be rewritten so it doesn't need that much
user-defined functions or split it up?
 
Back
Top