Results 1 to 2 of 2
  1. #1
    Join Date
    Apr 2002
    Posts
    25

    Unanswered: Number of characters in a record (excluding Memo and OLE Object fields) 2,000

    Number of characters in a record (excluding Memo and OLE Object fields) 2,000

    That is taken from the MS access specifications in help.

    Can somebody please explain exactly what that means. Would this be the cause of "Property Value Too Large" when I attempt to save rather large tables?

    I have a table with 209 fields in it, many are 35 character text fields. In its home database, I can not open up the talbe in design view at all. I simply get the message "Porperty Value is Too Large" and I am booted back to the database window.

    However, if I import ONLY that table into an empty database, I can open it in design view, but I still get the "Property Value is too Large" error if I try to add ANY new field and save the table.

    Help on my problem would be appreciated, as would any explanation of the max number of characters in a record.

  2. #2
    Join Date
    Apr 2002
    Posts
    25
    Oh, and btw, importing ALL of the objects into a new database results in the same problem.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •