error message changing data type

  • Thread starter Thread starter David H
  • Start date Start date
D

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.
 
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
 
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.
 
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
 
Back
Top