I have read the previous area on this error but it did not help. So, want to reask it.
We converted a Access97 database to 2000. When I try to save a table definition, I get the error Unknown function 'Date$()' in validation expression or default value on 'Box Table. Date Box Created. This field is a date field that should default to today's date.
However, since conversion, I cannot get to work. One of my coworkers, who appears to have same version of MSaccess 2000 that I have, it works fine after she installed Disk 2. No go for me.
My search of MS Knowledge and others say this is a missing dll or reference. I opened up a blank module and clicked on References. I have one missing. Its the DAO 2.5/3.5 compatability file. How do I put this back and get this to work?