How to interpret Compacting error message

  • Thread starter Thread starter doyle60
  • Start date Start date
D

doyle60

When I "compact and repair" my Access 2000 database, I get the
following message at the end of the process:

Could not find field 'Description'.

When I press on the Help in that message box, I get a blank box.

I don't have a field called Description in any table, nor in any query.


How do I resolve the issue?

Thanks,

Matt
 
Hi.
I don't have a field called Description in any table, nor in any query.
Click to expand...

That's the field name in a system table that holds information about errors
when the compact and repair fails. On very, very rare occasions, the cause
of this error message is a self-join on a memo field, so please see the KB
article on the following Web page first to ensure that this isn't the cause:

http://support.microsoft.com/?kbid=296389
How do I resolve the issue?
Click to expand...

If the cause isn't a self-join on a memo field, then you'll need to replace
the corrupt database with a good backup. You do have a backup, don't you?

If not, then at least one table definition is scrambled and you can probably
retrieve the rest of the database objects and data, but it may be a lot of
time and effort on your part to recreate the corrupted table(s) and the
affected data. Try creating a new database and importing the objects from
the original database one group at a time: first tables, then queries, then
modules, then forms, et cetera.

HTH.

Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips.

(Please remove ZERO_SPAM from my reply E-mail address, so that a message
will be forwarded to me.)

- - -
When you see correct answers to your question, please sign in to Microsoft's
Online Community and mark these posts, so that all may benefit by filtering
 
The error popped up after two fields were added to a table and this
data was entered in by copying and pasting from an excel spread sheet.
The table probably had about 100 records to it.

The issue was fixed by hand entering the data.

I have another database that loads in data every day from excel spread
sheets sent to me. I never had a problem before. Maybe one of the
cells was currupted in the excel or something. Don't know. But thanks,

Matt
 
Glad you resolved the problem. Good luck!

Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips.

(Please remove ZERO_SPAM from my reply E-mail address, so that a message
will be forwarded to me.)

- - -
When you see correct answers to your question posted in Microsoft's Online
Community, please sign in to the Community and mark these posts, so that all
may benefit by filtering on "Answered questions" and quickly finding the
right answers to similar questions. Remember that the best answers are often
given to those who have a history of rewarding the contributors who have
taken the time to answer questions correctly.
 
Back
Top