"Too many fields defined" issue

forest8 wrote:
Hi there

I have an access table that has about 255 columns.

Several fields need to be adjusted to a Yes/No instead of its current
setting of text.

When I try to change it, I get a "Too many fields defined" message that pops
up.

Followed by "Errors were encountered during the save operation. Data types
were not changed. Properties were not updated."

What is the best way to resolve this?

Thank you in advance.



While this doesn't address your current situation, you may want to take
a look at Question Pro. We used it here for a while and price wise it's
reasonable. Might be a better tool for the job.

http://www.questionpro.com/

I don't work for them or benefit from their sales yada yada. Just liked
their program.

gls858

"forest8" wrote in message
...
Hi there

I have an access table that has about 255 columns.

Several fields need to be adjusted to a Yes/No instead of its current
setting of text.

When I try to change it, I get a "Too many fields defined" message that pops
up.

Followed by "Errors were encountered during the save operation. Data types
were not changed. Properties were not updated."

What is the best way to resolve this?

Thank you in advance.



You'd have to delete a field and pack the database before you could add another field.
Changing a field type is like adding a new field, copying the data from the old field
and then deleting the old field. You can't do that when you already have 255 fields.

You might try writing a make table query that creates a new table with half the fields
from the original table, delete the copied fields from the original table, then relate the
two
tables in a one-to-one relationship.

Tom Lake