Error after reparing

[Rodolfo Fontes]

Hi group,

After compacting and reparing, a table called appear with some data inside,
that i don't understand, below some examples
ErrorCode ErrorDescription ErrorRecid ErrorTable
-1206 Could not find field 'Description'. T Produtos_Itens
-1206 Could not find field 'Description'. T Produtos_Itens
-1206 Could not find field 'Description'. T Produtos_Itens
-1053 Could not find field 'Description'. T Produtos_Itens
-1017 Could not find field 'Description'. T Propostas
-1522 No unique index found for the referenced field of the primary
table. T Pedidos_E_Det
-1522 No unique index found for the referenced field of the primary
table. T Pedidos_S_Det
-1522 No unique index found for the referenced field of the primary
table. T Pedidos_Fob_Estagios_Det
-1522 No unique index found for the referenced field of the primary
table. T Pedidos_Fob_Estagios_III_Det
-1613 You cannot add or change a record because a related record is
required in table 'T NatRD_S2'. T Produtos_Itens
-1522 No unique index found for the referenced field of the primary
table. T Produtos_Atualizacoes
-1522 No unique index found for the referenced field of the primary
table. T Produtos_Movimentos_Internos
-1522 No unique index found for the referenced field of the primary
table. T Pedidos_Fob_Det
-1613 You cannot add or change a record because a related record is
required in table 'T NatRD_S2'. T Produtos_Itens
-1522 No unique index found for the referenced field of the primary
table. T Requisicoes_Internas_Det
-1522 No unique index found for the referenced field of the primary
table. T Produtos_Movimentos
-1522 No unique index found for the referenced field of the primary
table. T Pedidos_Fob_Estagios_II_Det
-1611 Could not find field 'Description'. MSysObjects
-1611 Could not find field 'Description'. MSysObjects
-1611 Could not find field 'Description'. MSysObjects
-1611 Could not find field 'Description'. MSysObjects
-1611 Could not find field 'Description'. MSysObjects


How could this happen?

Thanks,
Rodolfo Fontes

 

[Tony Toews]

After compacting and reparing, a table called appear with some data inside,
that i don't understand, below some examples
ErrorCode ErrorDescription ErrorRecid ErrorTable
-1206 Could not find field 'Description'. T Produtos_Itens
-1206 Could not find field 'Description'. T Produtos_Itens
-1206 Could not find field 'Description'. T Produtos_Itens
-1053 Could not find field 'Description'. T Produtos_Itens
-1017 Could not find field 'Description'. T Propostas

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
http://support.microsoft.com/?kbid=296389 But it's more likely to be a
sign of corruption

How could this happen?

These are all signs of corruptions. If at all possible I'd go to the
backup and rekey the data.

Did you make a copy of the MDB before you did the repair? If so try
importing from that MDB. Or try some of the other things at the below
URL.

For more information on corruption including possible causes,
determining the offending PC, retrieving your data, links, official MS
KB articles and a list of vendors who state they can fix corruption
see the Microsoft Access Corruption FAQ at
http://www.granite.ab.ca/access/corruptmdbs.htm

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