We help IT Professionals succeed at work.

DAO problem

Lucsat
Lucsat asked
on
Medium Priority
230 Views
Last Modified: 2013-11-20
I have a buffer that it has a size of 500Kb. I want to insert it into a .mdb file. If I use the CDaoDatabase.Execute statement, an CDaoException "Out of memory" appears.

How can I insert this field? (I have 10 fields more in the insert statement).
Comment
Watch Question

Commented:
I think you're going to have to stop using ACCESS for this purpose.  I believe the limit for a BLOB in an Access mdb is about 32K.  I'm sure that this is intentional on Microsoft's part so that you must go to SQL Server if you are doing something "serious".

If you must continue to use Access, soncider breaking your 500K BLOB into multiple pieces smaller than 32K or store it in a file and have the database store a link to the file's pathname.
No comment has been added lately, so it's time to clean up this TA.
I will leave a recommendation in the Cleanup topic area that this question is:

Answered by: jhance

Please leave any comments here within the next seven days.

PLEASE DO NOT ACCEPT THIS COMMENT AS AN ANSWER!

Roshan Davis
EE Cleanup Volunteer

Explore More ContentExplore courses, solutions, and other research materials related to this topic.