Slow query with user-defined functions

[Martin]

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...

 

[Allen Browne]

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.

 

[gandalf]

Could the query be rewritten so it doesn't need that much
user-defined functions or split it up?

 

[Martin]

Thanks gandalf, I'll try that.

Also thanks for the bad news Allen and I would like to re-recommend to
everyone else your excellent site for tips on Access:
http://allenbrowne.com/tips.html.

Martin