Acces-"Unrecognized function name" using fn in query. ok pre-2003

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

Guest

I'm using a user-defined function for a search criteria in a query. After
upgrading clients to 2003, I get "Unrecognized function name" when I try to
run it. The function is public and it should see it. It even shows up in
the list when I use the Build window. Please help. Thanks in advance.
 
There's a chance one of your References is marked "MISSING". Open a module,
click Tools|References and check. If any are, uncheck them, close/save,
then re-open and re-check. Re-compile.

Regards

Jeff Boyce
<Office/Access MVP>
 
You may have "macro security" set to prevent user defined functions
in queries.

(david)
 
Thanks Jeff. That was definitely something to check. Hadn't thought of it.
They were all ok. David nailed it. Macro Security was set on medium (by
default i guess). Changed it to Low and it worked.

Jason
 
Back
Top