Corruption after a bunch of queries

[JR]

I have to rename some columns and add some new ones. I have a
macro/module that runs a bunch of column creation scripts, copies the
data from the source columns to the new columns, and deletes the
original columns. All seems ok, except when I do a compact and repair
I get a new table with a bunch of Could not find field 'Description'.
in it with an error code of -1026. Any idea what's going on? May have
to switch to SQL Server where I can more directly rename a column but
would prefer to stick with Access if possible.

JR

 

[Tony Toews]

I have to rename some columns and add some new ones. I have a
macro/module that runs a bunch of column creation scripts, copies the
data from the source columns to the new columns, and deletes the
original columns. All seems ok, except when I do a compact and repair
I get a new table with a bunch of Could not find field 'Description'.
in it with an error code of -1026.

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 could 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

 

[JR]

Thanks Tony, I've seen this response throughout the forum for others
however not sure it applies. My DB has a single table with one primary
key and many memo fields. Everything I red about referential integrity
has to do with relations between multiple tables. Is this the case?

 

[Tony Toews]

Thanks Tony, I've seen this response throughout the forum for others
however not sure it applies. My DB has a single table with one primary
key and many memo fields. Everything I red about referential integrity
has to do with relations between multiple tables. Is this the case?

But does that single table have a self join in it? For example it's
an employee table with a supervisor field. And the supervisor field
has a relationship back to the employee table.

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