Form Keeps getting Corrupted

[JamesJ]

I have a table that has 2 memo fields. Seems like every few days the
form I put one of the memo fields on becomes corrupt. (shows #Deleted)
The other form that I put the other field on I have no problems with.
Any ideas??

James

 

[Jeff Boyce]

James

You did say "any ideas??"...<g>

You mention both forms and fields. The one form is displaying #Deleted ...
but is the data still in the underlying table?

Are the forms located in a Access database located on your PC, or on a
network share?

--
Regards

Jeff Boyce
www.InformationFutures.net

Microsoft Office/Access MVP


Microsoft IT Academy Program Mentor
http://microsoftitacademy.com/

 

[Rick Brandt]

I have a table that has 2 memo fields. Seems like every few days the
form I put one of the memo fields on becomes corrupt. (shows #Deleted)
The other form that I put the other field on I have no problems with.
Any ideas??

James

That would usually mean that the memo field in the record is corrupted,
not that the form is.

Do you have multiple users in the same file at the same time? If so,
that is known to increase corruption problems. Beyond that is bad
hardware either the disk or network if working over one.

 

[JamesJ]

The data was gone from the table which is linked to my front end db.
I deleted the field and tried to drag the field back onto the form but
Access 2007 gives me this very long error message explanation.
I must delete the form and start from scratch. In fact, I must delete the
field from the table and recreate it.

 

[JamesJ]

I'm the only person running this machine. I must delete the field
from the table and delete the form and start form scratch.
The only difference between these 2 fields the unicode
compression was set to yes in the corrupted? field.

James

 

[Rick Brandt]

The data was gone from the table which is linked to my front end db. I
deleted the field and tried to drag the field back onto the form but
Access 2007 gives me this very long error message explanation. I must
delete the form and start from scratch. In fact, I must delete the field
from the table and recreate it.

And that is what proves that the table is corrupted and not the form. If
you re-created the table and gave it the same name the form would work
without messing it with it.

 

[JamesJ]

I have another memo field in the same table on another form
that there is no problem with .

James

 

[Rick Brandt]

I have another memo field in the same table on another form that there
is no problem with .

Doesn't matter. It is still the table that is corrupted, not the form.
I can;t rule out that something about the form might be causing the
corruption, but the form itself is not corrupted.

Memo field data is not stored in the table. It is stored separately on
disk with only a pointer to it stored in the table. The error you are
seeing is when the pointer is incorrect or lost.

 

[JamesJ]

ok. I'll replace the table. No big deal just 2 fields.

Thanks,
James

 

[troy23]

I had the same problem and I found it was due not shutting the system
down properly. Powering off the PC without exiting Access or Windows
via the normal channels

For FREE Access ebook and videos click here
http://access-databases.com/ebook