Record Corruption

  • Thread starter Thread starter JamesJ
  • Start date Start date
in-line:

JamesJ said:
In my case none of the things you mentioned occurred.
There is a possibility that power might have been interrupted
and the computer shut down but I can't recall that happening.
In that case wouldn't all my memo fields become corrupt?
Click to expand...

No, only the one beign written to, or at worst several records on the same
data page.
I'm not on a network and don't share the db with anyone and
I have no settings allowing my computer to sleep.
Click to expand...

That could be a function of the hard drive. "Green" computers often have
hard drives that spin down when a computer hasn't been used for several
minutes.
I to never had problems with memo field corruptions when I
ran my db with access 2003. Only since I've been uising ac 2007
has this problem poped up.

Have you converted your db to 2007 format, ran it for a while
and see if the memo fields become corrupted?
Click to expand...

I only use the MDB format so that it's compatible with other versions.
 
Although I'm not familiar with electrical stuff, my power must be
"flickering" more now that I'm running ac 2007 as apposed to when I was
running ac 2003.?

James
 
In fact when the memo field gets corrupt I'm able to copy the
contents of the memo field to the clip board delete the data form
the memo field at the table level and then paste it beck.
Click to expand...

If you can do this, then it's not the same kind of memo corruption
as we saw in previous versions of Jet. Is this an ACCDB or an MDB?
If the former, is it an append-only memo field?
 
In my case none of the things you mentioned occurred.
There is a possibility that power might have been interrupted
and the computer shut down but I can't recall that happening.
In that case wouldn't all my memo fields become corrupt?
I'm not on a network and don't share the db with anyone and
I have no settings allowing my computer to sleep.
I to never had problems with memo field corruptions when I
ran my db with access 2003. Only since I've been uising ac 2007
has this problem poped up.
Click to expand...

Are you running AV software?
 
ACCDB

David W. Fenton said:
If you can do this, then it's not the same kind of memo corruption
as we saw in previous versions of Jet. Is this an ACCDB or an MDB?
If the former, is it an append-only memo field?
Click to expand...
 
Nope


Jeff Boyce said:
James

Any chance there's a wireless LAN involved here somewhere? That can also
cause problems...

Regards

Jeff Boyce
Microsoft Access MVP

--
Disclaimer: This author may have received products and services mentioned
in this post. Mention and/or description of a product or service herein
does not constitute endorsement thereof.

Any code or pseudocode included in this post is offered "as is", with no
guarantee as to suitability.

You can thank the FTC of the USA for making this disclaimer
possible/necessary.
Click to expand...
 
Sorry didn't read far enough.
I really don't know.
I've looked at the properties of the memo and see no property for Append
Only.
Where might I find that property?

James
 
Back
Top