error message changing data type

[David H]

getting error message - "too many fields defined" I can not change any data
type. I have 170 fields, some I need to change to text and decimal or
currency. I can not change any.

 

[Clifford Bass]

Hi David,

Not sure why it would complain. Before continuing, make sure you have
a backup. Have you tried a compact and repair? If that does not help, how
about creating a new table with the columns defined as needed? Then create
an append query to copy the data from the original table to the new one. If
all goes well, delete the original one and rename the the new one to the
original's name. Or, just rename the original to something like
tblOriginal-Old and the new one to the original's name. Then you still have
the old table until you feel really confident about removing it.

Clifford Bass

 

[Duane Hookom]

In addition to Clifford's info (especially the compact), is there really a
good reason for more than about 30 fields? This sounds highly un-normalized.

 

[David H]

Compact and repair seems to be working. File size was over 9 MB, now its 1.9
MB
Thanks

 

[Clifford Bass]

Hi David,

I wonder if that means that a much modified table "retains" the older
information / columns until the compact, even though they are "deleted". (No
answer expected.) That would make sense in some ways.

Anyway, you are welcome!

Clifford Bass