Error message

[Guest]

I am modifying some of the fields in my dbase. I want to change from a
Yes/No format to a text format, however whenever I try to save the table I
get an error message - Too many fields active - Error code 3190. I am only
trying to work on one field at a time.

 

[Allen Browne]

The issue is probably that your table needs to be broken down into a
relational structure.

First compact the database:
Tools | Database Utilities | Compact

Then ask Access to give you suggestions on how to improve this table:
Tools | Analyze | Table

Chances are than you have a bunch of repeating fields. For example, if you
are tracking which colors a client likes you have fields like this:
ClientID autonumber
ClientName text
Red yes/no
Blue yes/no
Green yes/no
...
Instead create a table where the color names. Fields:
ColorID text

Then create another table with just these fields:
ClientID Number (relates to Client.ClientID)
ColorID text (relates to Color.ColorID)
This table has one record for each combination of client+color.