Data Integrity

[Jonathan Wood]

I've been using Microsoft Access for many years to track my customer orders.
For the most part, it appears to do the job.

However, I'm noticing that the data appears to be corrupt somehow. Queries
and other operations are increasingly showing certain orders twice when only
one should be displayed. I've had other strange problems trying to delete
certain orders as well.

I've used Access's repair utility but it does not solve this problem.

Has anyone else ever seen this? Is there a known fix? Perhaps a more
reliable way to rebuild the data (it's grown fairly complex).

Thanks!

 

[DL]

The only time I ever - so far! - experienced a problem, it transpired to be
a failing hd

 

[Jonathan Wood]

Well, that's possible I guess. But it's been ongoing for years now. I
would've expected the hard drive to fail by now if that was the problem.

Thanks.

 

[DL]

Then that doesnt appear to be the problem.
Perhaps you should examine carefully your underlying code.
Also perhaps check your MDAC installation
http://www.microsoft.com/downloads/...f6-4a21-4b43-bf53-14332ef092c9&displaylang=en

http://tinyurl.co.uk/0uqb

 

[Wayne Morgan]

As long as the data in the tables is sound, the only time I've seen that has
appeared to have been corrupted indexes. Doing a Compact of the database
will rewrite the indexes.

For more information on corruption, see this link:
http://members.iinet.net.au/~allenbrowne/ser-47.html