I've searched all over for information on this, and it seems like DAO paramaters in Access are restricted to 255 characters.
Really? Still? Even in Office 2010? It seems absurd. I'd prefer not to switch to ADO, but at this point it seems like I'll have to.
Is there any way to work around this while still using DAO and VBA code?
And are there any methods at all that allow using named parameters in queries that are over 255 characters in length, DAO or otherwise?
Short Text In Access web apps the Short Text field is set to store 255 characters by default, but you can adjust the Character Limit property all the way up to 4000 characters.
The Text data type is used for short text fields of limited length, and can contain up to 255 characters. A Memo field is a virtually unlimited text field. It can store up to 1GB of text.
Right-click the column to the right of the position where you want to add the new Memo field and select Insert Field. Select the field and click the Fields tab. Click More Fields and select Memo . Double-click the header row and enter a name for the new field.
While in the text box hold SHIFT down and press F2.
Your choice is dynamic sql, a recordset or ADO, I am afraid.
Access Specifications 2010
And it's the same for 2013 as far as I can tell from a test.
I've done sometime in access 2000 this including the contents of the memo field inside the sql statement, not as a paramenter. In order to do this, I had first to preprocess the memo field to duplicate each " inside the memo.
Hope it helps.
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With