Undefined Function 'dir' - References are all ok

[rheide]

I currently have a query that uses the dir function. The exact field in the query is as follows:
filecheck: IIf(Dir([filelocation])<>"","Y",IIf([rndate] Is Not Null,"R","N"))

This has worked great over the last 2 years using Access 2000 and Access 2002.

Recently I upgraded to Access 2003 and realized that there were a few things that were not working and rather than messing around with it, I decided to revert back to Access 2002. After doing this on my laptop, the query above worked great. After doing this on my desktop, I still get the undefined function 'dir' error.

Both computers are running Windows XP Professional with Office 2003 except for Access which is 2002.

Here is a screenshot of the References on my desktop computer (just to show that there aren't any MISSING entries):

Does anyone have a suggestion for me?

Thanks in advance,
Randy

 

[Rich]

They don't have to be Missing, they could be broken.
Search the archives here for solutions

 

[rheide]

Hi Rich,
I've run into the same issue in the past and I always reference this for more help: Access Reference Problems

I've done the following things:
1) Re-registered each reference / Compiled - same error
2) Removed all references / Added them back / Compiled - same error
3) Tried running DLL Version Identifier db that I downloaded from here so I could compare it to my other machine. Only problem is when I open it, I get a "Undefined function 'FileDateTime' in expression" error.

I will keep searching and troubleshooting,
Randy