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

Analyze Tool & Lost Data

P: n/a

I want to report a problem I had with splitting a table using the
anaylze tool. I started with 92000 records and in the child table
ended up with around 10,000 records. Now I assumed that access did
it's best to remove duplicates and achieve a degree of data
normalization. Which was indeed the case. All well and good until a
few weeks later I discover to my horror.....missing data! and so I
repeated the whole scenario and ended up with the same result. Around
200 unique records that existed before the spit disappeared after the
split. In the end I made sure the split didn't remove any duplicates
by include a unique key and then I removed the duplicates with my own

Anyhow, I'd be interested to know if anyone else has had this problem
or knows how this might happen.

Dec 15 '05 #1
Share this question for a faster answer!
Share on Google+

This discussion thread is closed

Replies have been disabled for this discussion.