Error message

  • Thread starter Thread starter jdm
  • Start date Start date
J

jdm

I was rolling along happily the other day when the DB I
was working on decided it didn't like me anymore.

I get an error message when trying to add more
fields/modify fields in my database.

It says that "Some Data May Be Lost" as Feild sizes have
been altered, - some validation rules may be violated. I
haven't set up any validation rules.

When I say go ahead and save anyway, it says too many
fileds are defined. What does this mean and how can I fix
it?
 
If you are getting a message that "too many fields are defined", that
suggests you have already reached the limit of 256 fields in your table. If
this is the case, then your database is most likely not normalized. You will
seldom find a fully normalized database table with more than 50 to 75
fields. I'm not sure I've ever created a table with even 50 fields, although
I've worked with some that large.
 
I only have 135 fields defined so far. There are over 250
records, but only 135 fields. So now what?
 
If this sounds like you...

"The internal column count that Microsoft Access uses to
track the number of fields in the table has reached 255,
even though you may have fewer than 255 fields in the
table. This can happen because Access does not change the
internal column count when you delete a field. Access also
creates a new field (increasing the internal column count
by 1) for every field whose properties you modify."

Try this link: http://support.microsoft.com/default.aspx?
scid=kb;en-us;291556&Product=acc
 
Back
Top