troubleshooting Question

Access 97 tables corrupted after conversion to 2003

Avatar of DJMTEK
DJMTEKFlag for Canada asked on
Microsoft Access
41 Comments8 Solutions352 ViewsLast Modified:
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?
ASKER CERTIFIED SOLUTION
harfang

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Join our community to see this answer!
Unlock 8 Answers and 41 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 8 Answers and 41 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros