unknown function name in query

[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

 

[Gary Walter]

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

This can typically be a References problem.

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

Are any marked as "Missing"?

 

[lygopc]

Thanks Garry,

No all the references look ok.

Any other ideas?

Paul

 

[Gary Walter]

search Google Groups

http://groups.google.com

on

unknown function name group:microsoft.public.access.*

 

[BruceM]

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