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.