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.

 

[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 ****s 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