Msaccess Memo Field Limits05 Mar 2008
One small part of my current job involves maintaining a legacy MS Access XP database, and I recently ran into an issue that caused some consternation.
In all the documentation I could find, the maximum length of a Memo field was 64K when the data was entered via the UI, and 1Gb when entered programatically. However the app was raising an error when I tried to insert more than 64K programatically. The field in question was in a linked table, with the actual table residing inside another access database.
The error I was getting was “Error 3035 - system resource exceeded”.
I used the following VBA method to test the theory. Most functions in the database use the old DAO instead of ADO for legacy reasons. We haven’t had enough reason to go through the pain of switching everything to ADO as yet. The error is raised by the db.Execute line.
By switching the test function over to ADO, I can now insert more than 64K into my memo field.
The lesson? Use ADO whenever possible.