Access 2000 date and time error on NT4 - TechRepublic
General discussion
October 9, 2000 at 03:15 AM
adisha

Access 2000 date and time error on NT4

by adisha . Updated 25 years, 5 months ago

I am trying to set default field values in a database I am creating to current date and time using the built in ‘=date()’ and ‘=time()’ functions respectively.

This works fine on Windows 98, but when I take use the database on an NT4 workstation machine I get the following error: Error in date and time fields and none of the datatypes in the table design view can be saved.

Can anybody tell me if this is a known bug in Access 2000? If so, how can it be remedied?

Many thanks for your help in Advance

IT Guru

This discussion is locked

All Comments