Access 97 tables corrupted after conversion to 2003
Access 97 database (front and back end). When I try to open and convert using Access 2003, certain tables don't get converted properly. Bothe their field names and types get changed (eg.
from text to autonumber, or text to number). And the data in these tables changes from text descriptions to just a bunch of numbers or blanks. Otherwise most other aspects of the database seems to work ok. Any suggestions how I can remedy this?
DatabaseMX (Joe Anderson - Former Microsoft Access MVP)
Be sure .. before you try to convert, that your A97 mdb will Compile. And of course, do a Compact and Repair prior to converting.