Record to Large

[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

 

[Allen Browne]

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

 

[Zamdrist]

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

 

[Allen Browne]

This happens because of the buffer size allocated to the record in JET.