By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
446,258 Members | 1,284 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 446,258 IT Pros & Developers. It's quick & easy.

Rows disappear when converting from Access 2007 to Access 2000

P: n/a
Hi all,

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
files.

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?

Thanks!

PS I would really love to sue evil uncle Bill :)
Mar 17 '08 #1
Share this question for a faster answer!
Share on Google+

This discussion thread is closed

Replies have been disabled for this discussion.