I had a database with 3 tables (no queries) in an Access 2007 file.
I converted the file to Access 2000 format, as that is the only Access
format recognized by the SQL server we have here.
Some sql queries gave weird results, so I went back to the original
To my surprise, I noticed that the Access 2000 version of the file was
trimmed: one table had been "shrunk" from half a million records to
128,000 ! More than a third of the rows had simply vanished, yet no
error message was ever given!
Has this happened to you? Do you have any idea how to prevent it?
PS I would really love to sue evil uncle Bill :)