record length

[davec]

After changing 10 text fields to memo fields in a table, we are getting an error message in a related form indicating that the allowable record length (2k I believe) has been exceeded. Even after substantially reducing the size of the table by pulling the memo fields into a separate table, we continue to get this message. It is as though the space allocation for records cannot be reduced by reducing the contents of the table. Is there any way around this issue, or is this table layout now virtually unusable? Thanks for any help.

 

[Pat Hartman]

In certain cases, Access retains a memory of what was and that may be causing the error. Compact the db to remove old information and that should solve the problem.

 

[davec]

Thanks for the suggestion Pat. The file was set to compact on close, and we also did a manual compact, but this did not solve the problem. Are there any other possible solutions that we can try?

 

[Pat Hartman]

Try Vivian's solution -
http://www.access-programmers.co.uk/forums/showthread.php?s=&threadid=59035