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