We have a Access database that a group of us share. We have been using it with Access 2000, running under Windows 98 SE without problem for a couple of years.
I have recently aquired a new machine running Windows 2000 and installed Access 2000. Now everytime I access this Access database it displays '#Name?' in the field on the form that has '=Date()' as the default value. I also have a message displayed that says 'Function is not available in expressions in table-level validation expressions'. If I enter the date in this field manually then it is OK, but when create a new record I get the same problem again!
It must be something to do with Windows 2000, as it works fine under Windows 98SE. I've checked the date format in Win 2000, and checked that the settings in Access 2000 are the same as the 98SE machines. Any ideas anyone ?