I have a database with a moderate number of records in several tables
(the biggest table at the moment is about 800 records). In development
it got moved between 2K and XP repeatedly. Several days ago, it
wouldn't open, and proposed creating a backup before fixing. OK, but
the "fixed version" didn't open -- same messages as the original -- but
the backup did. But, in the 800 record table only 200 records
appeared. We went back several days of daily backups, and opened one of
those (which presumably had worked for several days after the backup).
It opened fine, but stopped at the same record.
So I emailed a copy of that file to work on in a different location,
where Access 2K is in use, and, lo and behold, all the records were
there. I did a compact and repair, sent it back to XP, and still only
see 200 records. We've since verified that even in the most recent
version, the one that wouldn't open in XP) 2K can see all the records.
Has anyone else come across this? And, if so, is there a known strategy
I can use to rebuild the tables in XP (like delete all records, send
from 2K to text, import text into XP, etc.)?
--
Steve
--
http://www.steveclaflin.com