A2K Dir() Function: It Works/It Works Me Not

[GGleason]

I am using the Dir() function in a query in an mdb converted from A97 (Win NT SP6) to A2000 SR-1 (W2K SP4). I get an error when I run the query that states "Undefined function 'Dir' in expression." When I go to the immediate window and do a ?Dir(), I get data and no error.

The query used to work in the older version. The query also works on another W2K/A2K machine (same OS and Access builds but different images). ARGHH! Can someone give me directions on where to look?

Thanks,
GGleason

 

[LarryDeLaruelle]

Check to make sure that you have the reference to DAO 3.6 set.

Open any module in design, click on Tools/References.


Larry De Laruelle
ldelaruelle@familychildrenscenter.org

 

[GGleason]

Larry,

When I saw your comments yesterday I started working feverishly to see if I could get a fix in place.

I copied and registered the DAO from the "good" PC to the "bad" PC, but still have the same problem. I think it is something along these lines (PC resident software) rather than a coding error. Another PC that was made with the same image as my "bad" PC had the same error on the same query, so it least it is consistent.

These problems are so hard to debug and it appears that this problem is above my pay grade.

At least I still have hope that I can fix it.

Thanks,
GGleason

 

[LarryDeLaruelle]

You might try doing a reinstall of Access on the 'bad' systems to see if that might fix the problem.

Larry De Laruelle
ldelaruelle@familychildrenscenter.org

 

[GGleason]

FYI:

The IT group where I work fixed the problem. They spent a lot of time looking into it and in the end it was a registry tweak.

Thanks,
GGleason