Problem with Date() in Access 2000 [Resolved]

[salvelinus]

I added a new table to about 50 Access 2000 db's (don't ask why there's 50 db's). This table has a LogDate field that I set to default to Date(). This works in every db but one, where an error is raised telling me that Date() isn't a recognized function. It is listed in built in functions. Now() works, which is what I ended up using, although it gives the time as well. I compacted and repaired the db, no change. Why won't it accept Date()? Thanks.

[Matt_T_hat]

Access 2000 is a funny beast, I too have to handle arround 50 seperate versions of a DB. Check to see what's so special about that install of Access is it 2003 / XP 97-upgrade or something?

Most importantly of all check the version of MDAC.dll as this is most often the problem.

On another note if you format the date field on the table the time portion of now() should be filtered from view.

[salvelinus]

Well, I fixed the problem. I updated the machine I was testing it on to the most recent MDAC, like you suggested, and added a reference to MS ActiveX Data Objects 2.1 Library. The program also raised errors on statements like Ucase() and Chr().
Not sure which of those actually fixed it, because I didn't test it between the two. It previously ran fine on my W2K machine. The error occurred on W98 machines.
It's Access 2000.
Thanks for the help.