Error in Access 2002

  • Thread starter Thread starter Noel
  • Start date Start date
N

Noel

I have a data base that keeps give me this error can you
please advise

microsoft access 2002 Error 3047 Record is too large

the record is only 2kb and a total of 64 records.

Cheers
Noel
 
If the record is more than 2000 characters wide, you need to change it.

Do you have repeating fields, e.g. Week1, Week2, ...? If so, create a
related table, and put all of those into one column, with a 2nd column to
handle the value 1, 2, or whatever.

Do you have lots of large Text fields (e.g. Text 255 characters)? Replace
the big ones with Memo fields. Regardless of how many characters are in the
Memo field, the only count as 10 out of your 2k width.
 
Back
Top