DATE() not recognised in certain versions of Microsoft Access

  • Thread starter Thread starter Guest
  • Start date Start date
G

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.
 
Db_Stuff said:
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.
Click to expand...

Explained at link below...

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