corrupted records

K

Karen

I have an Access application that we use to maintain Complaints/Returns
called in by customers. The database is split so that the tables are on a
network drive and the frontend is installed on everyones computer. Most of
the users don't have Access on their computer so we install the Access
runtime. On occasion we get records that start out okay and somewhere along
the line they will get corrupted and display all sorts of characters that
don't make any sense to us. What is happening to the records? How do I stop
it from happening?

Thanks in advance for your help.
Karen
 
J

John Vinson

I have an Access application that we use to maintain Complaints/Returns
called in by customers. The database is split so that the tables are on a
network drive and the frontend is installed on everyones computer. Most of
the users don't have Access on their computer so we install the Access
runtime. On occasion we get records that start out okay and somewhere along
the line they will get corrupted and display all sorts of characters that
don't make any sense to us. What is happening to the records? How do I stop
it from happening?
Click to expand...

Check out the suggestions at Tony Toews' corruption FAQ:

http://www.granite.ab.ca/access/corruptmdbs.htm


John W. Vinson[MVP]
 
T

Tony Toews

Karen said:
I have an Access application that we use to maintain Complaints/Returns
called in by customers. The database is split so that the tables are on a
network drive and the frontend is installed on everyones computer. Most of
the users don't have Access on their computer so we install the Access
runtime. On occasion we get records that start out okay and somewhere along
the line they will get corrupted and display all sorts of characters that
don't make any sense to us. What is happening to the records? How do I stop
it from happening?
Click to expand...

Thanks to John for posting a link to my website.

This sounds like a intermittently flaky hardware problem. And these
can be the worst to figure out.

I did see this kind of problem in person at a site where the office
was in an old house with inadequate power. Every computer had a UPS
as they were frequently getting brownouts and short outages. Trouble
is the hub didn't have a UPS so it was scrambling the data.

OTOH it could be just about anything else too.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
 
Top