Corrupted?

[Ig]

Hi,
My database works well, but every time when compacting it, the following
message pops up:
"Could not find field 'Description'". After that everything continues to
work well (at least it seems to).
Any suggestions?
Thanks

 

[Allen Browne]

It does sound like Access is confused about something. Some objects have a
Description property, or perhaps you used to have a field named Description.

First thing would be to ensure that the Name AutoCorrect boxes are unchecked
under:
Tools | Options | General | Name AutoCorrect
Explanation of why:
http://allenbrowne.com/bug-03.html

If that does not solve the problem, get Access to rebuild the database for
you by following the steps for the first symptom in this article:
Recovering from corruption
at:
http://allenbrowne.com/ser-47.html

 

[Guest]

Hi Ig,

See Access MVP Tony Toews page:
Some Microsoft Access MDB Corruption Symptoms
http://www.granite.ab.ca/access/corruption/symptoms.htm


This page includes the following:

1017 - "Could not find field "Description" It's possible the problem is with
a table that has a self-join and Memo fields, and has referential integrity
enforced. ACC2000: Table Corruption After Referential Integrity Checks -
296389 But it's more likely to be a sign of corruption.


Follow the instructions provided on the page that Allen Browne just gave you.


Good Luck,

Tom

http://www.access.qbuilt.com/html/expert_contributors.html
__________________________________________



:

Hi,
My database works well, but every time when compacting it, the following
message pops up:
"Could not find field 'Description'". After that everything continues to
work well (at least it seems to).
Any suggestions?
Thanks

 

[Ig]

Thanks guys