Error on quitting

T

Theennus

Whenever I quit a FE database on a client, I get a "Couldn't find the field
'Description'" dialog. After choosing OK, Access closes, but a new file on
the same folder is created, it is the same FE file, but it is not compacted.

How can I avoid this 'error'?
 
T

Tom Wickerath

Hi Theennus,

This message is often times a sign of database corruption. Check out Tony
Toews page here (8th bullet):

http://www.granite.ab.ca/access/corruption/symptoms.htm

Here is some very useful information for how to prevent corruption in the
future:

Causes of Corruption
Preventing Corruption (Allen Browne)
http://allenbrowne.com/ser-25.html

Corrupt Microsoft Access MDBs FAQ (Tony Toews)
http://www.granite.ab.ca/access/corruptmdbs.htm


So, how to deal with it right now? Try the following:

Create a brand new database in Access 2000, immediately disable the
NameAutocorrupt feature (see: http://allenbrowne.com/bug-03.html for reasons
why you want to do this). Then import all objects from the suspect database
into the new database, one group at a time, into your new database. In other
words, import all tables (but not linked tables), then import all queries,
then all forms, etc. While Access will allow you to import all objects in one
operation, the experts at FMS, Inc. (a Microsoft Partner), have stated that
it is best to import objects one group at a time. Recreate any linked tables
from scratch. When importing local tables, make sure to check the option to
import relationships, menus and toolsbars, and import/export specs. If any of
the local tables in the source DB are hidden, you'll need to first unhide
them.

You will need to set the checked references to match the source database,
along with any startup options set under Tools > Startup. Going through this
process often times solves corruption problems, because you get a new set of
the hidden system tables (the tables whose names start with "MSYS"). These
system tables are updated appropriately as you import objects.

This may sound like a lot of work, but it really isn't. Creating a new
container DB, disabling NameAutocorrect, importing all objects one group at a
time, and setting startup options and references to match the source DB is
usually a fairly quick procedure. When you are in the Visual Basic Editor, in
order to check that the references match the source DB, you should do a Debug
Compile ProjectName as well. You want to re-create any linked tables from
Click to expand...
scratch, because Access can cache a lot of information about linked tables,
which may no longer be valid, so it's always best to recreate the linked
tables from scratch.


Good Luck,
Tom

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

:

Whenever I quit a FE database on a client, I get a "Couldn't find the field
'Description'" dialog. After choosing OK, Access closes, but a new file on
the same folder is created, it is the same FE file, but it is not compacted.

How can I avoid this 'error'?
 
Top