Record to Large

  • Thread starter Thread starter Zamdrist
  • Start date Start date
Z

Zamdrist

Running an append query to a table, the query is merely a select from
a pass-through query, which works. Previewing the result of the append
query works, but running it does not.

"Record too Large"

Never seen that before...ideas?

Thanks
 
If you sum the size of the actual data in a record (number of charcters in
each text field, 4 bytes for a Long, 8 bytes or a Double or Date/Time, 10
bytes for memo (regardless of the actual number of characters--it's just the
address that counts)), there is a finite size the record can be.

In earlier versions of Access, it was approximately 2000 characters. In more
recent versions, it can be up to 4k characters, though MS says this depends
on factors such as your language and Unicode Compression. But if you
actually have a record wider than that, you will get the 'record too large'
error.

Since this depends on the actual data in each record, it's possible to have
a database that works for a while until you actually get a record that's too
wide. Therefore, this is one of the issues we check for in this utility:
Database Issue Checker
at:
http://allenbrowne.com/AppIssueChecker.html
 
Thanks Allen.

I presume this happens due to the difference in the attributes between
the SQL Server data type varchar and MS Access text types?

Steve
 
Back
Top