How to DETECT if records corrupt in table.

[ThomasAJ]

This is not about "how to fix" but how to detect.

From time to time I get a corrupted record in a couple of tables.

Is there any way to detect such occurrences before it is bought to my
attention by garbled contents on a user's form.

eg can I run say code to read every record in a table and maybe an error
message is issued which my program can pick up.

 

[Steve]

Tom,

Give a couple of examples of what you mean by a corrupted record to help us
give you a definitive answer.

Steve
(e-mail address removed)

 

[ThomasAJ]

When the record is viewed manually by opening the table within Access the
contents are garbled (look like Chinese characters to me - not really Chinese
- but the BITS making the BYTE have been scambled so most bytes are not the
'normal' viewable characters) and the record cannot be deleted.

--
Regards
Tom

Tom,

Give a couple of examples of what you mean by a corrupted record to help us
give you a definitive answer.

Steve
(e-mail address removed)

 

[Gina Whipp]

ThomasAJ,

I think that an issue is being overlooked which is why these records keep
getting corrupt. Can you tell us a little about the table set-up and you
network set-up? Also, what version of Access and Windows.

I don't need an example of your corrupted record, I saw one once, very
annoying as I don't speak or read Swhaili! I do not know of a way to detect
those characters and not sure one exists but hoepfully if someone knows a
way they will post a reply.

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

 

[Tony Toews [MVP]]

From time to time I get a corrupted record in a couple of tables.

Is there any way to detect such occurrences before it is bought to my
attention by garbled contents on a user's form.

eg can I run say code to read every record in a table and maybe an error
message is issued which my program can pick up.

Is the corrupting field usually a memo field?

See Corrupt Records in a Microsoft Access MDB for one approach.
http://www.granite.ab.ca/access/corruption/corruptrecords.htm
You could insert each of your field names in that loop. Or use a DAO
collection to loop through all the fields in the table.

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
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/

 

[Gina Whipp]

Thank you Tony... I just learned something new!

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

 

[ThomasAJ]

"I think that an issue is being overlooked which is why these records keep
getting corrupt."

Deliberately at the moment - it's a seperate issue.

--
Regards
Tom

ThomasAJ,

I think that an issue is being overlooked which is why these records keep
getting corrupt. Can you tell us a little about the table set-up and you
network set-up? Also, what version of Access and Windows.

I don't need an example of your corrupted record, I saw one once, very
annoying as I don't speak or read Swhaili! I do not know of a way to detect
those characters and not sure one exists but hoepfully if someone knows a
way they will post a reply.

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

 

[Gina Whipp]

Tom,

Okay, as long as you are aware this could cause additonal issues down the
road... You know, the domino effect!

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

"I think that an issue is being overlooked which is why these records keep
getting corrupt."

Deliberately at the moment - it's a seperate issue.

 

[Tony Toews [MVP]]

"I think that an issue is being overlooked which is why these records keep
getting corrupt."

Deliberately at the moment - it's a seperate issue.

For more information on corruption including possible causes,
determining the offending PC, retrieving your data, links, official MS
KB articles and a list of vendors who state they can fix corruption
see the Microsoft Access Corruption FAQ at
http://www.granite.ab.ca/access/corruptmdbs.htm

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
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/

 

[aaron.kempf]

Dude if you want to avoid corruption-- then move to SQL Server

Jet randomly corrupts and these fat lazy fucks don't have any answer
other than 'run around randomly trying 10,000 different things and
then maybe when it corrupts-- we can blame it on the network'

**** that

Jet corrupts

move to SQL Server if you give a shit about your data