Can't change data types in existing table - says too many fields defined

[mcomp72]

Hey Micron. Wow... that website looks like it will be incredibly helpful as I continue learning Access. Thank you!

[ssanfu]

Barry Williams has a web site for Industry Data Models
http://databaseanswers.org/data_models/index.htm

Maybe his examples will help.....

Timesheet examples:
http://databaseanswers.org/data_mode...eets/index.htm
http://databaseanswers.org/data_mode...eets/index.htm
http://databaseanswers.org/data_mode...time/index.htm

<snip>I don’t think it’s a maximum number of columns issue, because I believe that number is 255, so I’m under that. <snip>

IIRC, 255 is the number of fields over the lifetime of the table.
So if you create a table with 230 fields, then delete 225 fields, you can only add 25 fields more, not 250. To add more fields, you would have to create a new dB and import all objects from the old dB to the new dB. Then you would be able to add more fields.

[June7]

Just tested. Created table with 255 fields. Then deleted 1. Could not add a new field. Ran Compact & Repair. Added new field.