CODEWITHSUNDEEP
ms-access
msbyuva
msbyuva

Reputation: 3615

can we store more than 65,535 characters in ms access database?

I am saving a string to ms access data base, memo is the data type for the field. My string will have more than 65,535 characters but memo can save only 65,535 characters. Is there any data types/way to save more than 65,535 characters in ms access database ?

Upvotes: 1

Views: 913

Answers (1)

Danny
Danny

Reputation: 132

You could save the string in a txt file and a link to the file location in de Database. Of course you can not query the text from the database but the txt file itself can be queried by code in VBA.

Second option is to save the file as an OLE-object in database. Althow it isn't much different from above. You still can't query it.

Hope it helps.

Upvotes: 1

Related Questions