Any way to have long text (memo) parameters in DAO and MS Access?

Question

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?

Fionnuala · Accepted Answer · 2012-08-23T23:27:19.057

5

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.

edited Aug 23 '12 at 23:27

answered Aug 23 '12 at 23:14

Fionnuala

90,370
7
114
152

See added note. It is not going to go way. – Fionnuala Aug 23 '12 at 23:27

score 2 · Answer 2 · answered Nov 03 '12 at 15:34

2

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.

answered Nov 03 '12 at 15:34

FGM

21
2

Any way to have long text (memo) parameters in DAO and MS Access?

2 Answers2

Linked