ERROR 3190

Question

in trying to add fields to database get recurring error message of too many fields, though am well under the 255 limit advised by error 3190 message

Answer 1

Try doing a compact and repair on the database containing the tables.  In the past that has taken care of the problem for me.

Access has 255 slots for fields in a table, but it uses up a slot if you redefine a field or add a field and then delete the field.  It does not recover the no-longer-used slots until you do a compact and repair.  So you can see 32 fields in the table, but you may have used up all the slots by changing field definitions (especially field types) and adding and then dropping fields.

I have to say that I have not run into this problem in years, but then I don't often redefine fields and my tables are almost all less then 20 fields.

Answer 2

Can you repeat the problem if you export the table to a new database? Perhaps you have some form of corruption.

With "well under 255" you mean "less than 50", right? Anything over that would smell like bad database design, unless you REALLY know what you are doing.