unknown function name in query

  • Thread starter Thread starter lygopc
  • Start date Start date
L

lygopc

I am using Access 2003.

I have a database query that I have been using for about 6 months year
without problems. Without making any changes to access (other than data) I
have started to get an error when I run the query "unknown function name in
query expression".

Any suggestions as to how I fix this?

Thanks

Paul
 
lygopc said:
I am using Access 2003.

I have a database query that I have been using for about 6 months year
without problems. Without making any changes to access (other than data) I
have started to get an error when I run the query "unknown function name in
query expression".
Click to expand...
This can typically be a References problem.

Open up a code module,
in top menu select Tools/References.

Are any marked as "Missing"?
 
I have seen this suggested, but have not had to use it, so I am not sure I
have this right, but go to Tools > References as described, select any
reference, close Access, reopen it, and deselect the reference you just
selected. This will cause Access to reset the references. You may need to
close Access again, then reopen it, but I'm not sure.
If you have not done so you should back up the database, then run Compact
and Repair (Tools > Database Utilities).
 
Back
Top