DATE() not recognised in certain versions of Microsoft Access

[Guest]

I hope some people out there might be able to help me. I have an Access 2002
database with various tables in it. If I go in to design view of any table
which has a date field in it and then modify the table design and save and
close the table it gives an error "This function is not Recognised". I go to
the date field and my default value for that field is set to : =Date() and it
doesnt recognise this function at all for some reason. This error hapens on
certain machines and on some it does not happen.

 

[Rick Brandt]

I hope some people out there might be able to help me. I have an
Access 2002 database with various tables in it. If I go in to design
view of any table which has a date field in it and then modify the
table design and save and close the table it gives an error "This
function is not Recognised". I go to the date field and my default
value for that field is set to : =Date() and it doesnt recognise this
function at all for some reason. This error hapens on certain
machines and on some it does not happen.

Explained at link below...

http://www.mvps.org/access/bugs/bugs0001.htm