I have a form with a Bound OLE Object to a varbinary(max) field in a linked SQL Server table.
This is being used to load PPTX, XLSX, DOCX, PDF files into the varbinary field.
I know this isn't the best solution for document management but it's what I got for this project.
I use the ole-object right-click, insert object..., create from file, browse... to the file and click on OK to load the file into the OLE Object.
All of the files will load into the ole control and display properly.
All of the files will allow for 'Open' or 'Show' them.
A few of the files when saving them will get a "Not enough memory to complete the Automation object operation on the Presentation object" and the save will abort. In this example the file being loaded was a PowerPoint PPTX file. After that error a "Sorry, an unexpected error has occurred, please exist and restart..." occurs
If I close the form and reopen it I can load and save any file that previously loaded with no error. But if I attempt the record save with one of these known to fail, the record save fails again.
There is no code behind the form events including load, current, before_Update and after_update.
I've tried quite a few approaches
Renaming file
Putting the file in different directory
Opening the PPT or XLSX and resaving under a new name
Just Small files 1.9MB
Just Large files 19.1 MB
Relinking the SQL Server linked table
Some others I can't remember
My Google-foo has not been good in the research.
Any suggestions or direction is greatly appreciated.
Stay Safe