Error 3047 - Record is too large.

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am populating a Table via code.

I am getting this Error Number.

Just guessing...A Table can have a max of 255 fields.
Is there a max of Characters if the fields are less than 255?

TIA - Bob
 
Bob Barnes said:
I am populating a Table via code.

I am getting this Error Number.

Just guessing...A Table can have a max of 255 fields.
Is there a max of Characters if the fields are less than 255?
Click to expand...

According to the help topic "Microsoft Access specifications", there's a
maximum of 2000 characters in a single record, excluding Memo and OLE
Object fields. Those fields are not stored in the same location as the
rest of the record, so they don't count.
 
Back
Top