Corruption of the database

  • Thread starter Thread starter Rasputin
  • Start date Start date
R

Rasputin

I have a problem:
I made and manage a database for a online sales company.

We have never before had problems, but suddenly the
database has gone corrupt twice in a few days, and I do
not seem to be able to reproduce the error.

I use an MSAccess2002 database. The site is not heavily
trafficked (I have a personal site that is far more
trafficked, and has never had problems with concurrencies).

This is the error I get when I repair the base (in the
MSysCompactError):
ErrorCode | Errordesc | ErrTable
-1206 | Could not find field 'Description'. | Order

Another error has number -1611, and yet another has -1053.
Furthermore it has a few errors on the MSysObject table
(not a table of mine)

The wierd thing is, that I have no field
called 'Description' on that table, and I never had.
My boss said it happened both times right after he updated
a memo field on a Ware, but I have not been able to
replicate that error...
The Order table has several times been altered, fields
have been added, and some have been renamed. Could that be
a problem?
 
Try first decompiling a COPY of the database file. This article should help:

http://www.mvps.org/access/bugs/bugs0008.htm

If that doesn't work, try importing all the objects into a brand new
database. If it isn't split into front and back ends, read the help files
and you the wizard to do it on a COPY. Now, you mentioned site. Is this
database being used on a website? If so, it is less of a problem with the
number of hits it is getting, but when they occur. Ten hits all at once, is
worse than 1000 dispersed throughout the day.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access
 
Thanx alot for the answer. I have tried and decompile, now
I just need to wait and see :)

But it sure sounded like it could solve my problem. Thanx!
 
Rasputin said:
This is the error I get when I repair the base (in the
MSysCompactError):
ErrorCode | Errordesc | ErrTable
-1206 | Could not find field 'Description'. | Order
Click to expand...

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 at support.microsoft.com. But
it's more likely to be a sign of corruption.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
 
Back
Top