I'm using MS Access 2K and my staff occasionally enters too much data for a specific record. I suspect the max record length for a record is being exceeded, however, a problem does not show up until the employee runs a query to append the table to a table on the back end.
Access fails when the append query is run and produces a "record too large" error, without any indication of which record has failed.
The table being appended may contain 50K or more records, so we need a programmatic way to identify the record that is too large.
I believe the max record size for Access 2K is 2018 without Memo fields but I'm not sure what that means. For example, how many characters are in a double field, date, etc?
Can anyone help?