error message changing data type

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

"David H" wrote:

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.

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.
--
Duane Hookom
Microsoft Access MVP


"Clifford Bass" wrote:

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

"David H" wrote:

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.

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

"Clifford Bass" wrote:

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

"David H" wrote:

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,

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

"David H" wrote:

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