troubleshooting Question

Need help finding bad records

Avatar of pcalabria
pcalabriaFlag for United States of America asked on
Microsoft Access
10 Comments1 Solution40 ViewsLast Modified:
Occasionally Access 365 C&R fails because one or more records have become corrupt.
When I get lucky, I see the corruption and may delete the record.  The bad record often has characters that appeat to be from an asian character set.. definitely not us characters.
Sometimes I find the bad contents by sorting, but never know which field to sort by..

is there any utility anyone knows that can find bad records so i can delete them and then compact?

Thanks
Join the community to see this answer!
Join our exclusive community to see this answer & millions of others.
Unlock 1 Answer and 10 Comments.
Join the Community
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 10 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros