This outta be a bit nostalgic for some.
I have a database in Access 97 that is converted from an old Dbase IV database. It has a date it converts to 1901 instead of 2001. (or 1900 instead of 2000)
How can I update all 4000+ records at the same time? Basically, I need an update query to look at the last 4 digits of a date and change it. Unless there is a better way.
Also, does anyone know a good Access 97 site?