How to Save a OLE Object as a File?

I

Ilídio Santos

Hello,
I have an Access database with a table containing a column of OLE Object
Type (Word documents).
It is filled with hundreds of records, that makes the database to be very
big and always growing.
Now I would like to retrieve the OLE objects and save them as ".doc" files
deleting the objects from the database to make it lighter.
How can I do it by code in VBA? Is there a simple way to save the embed OLE
Objects as physical files?

If You have a solution, please help!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

OLE Server and ActiveX Error 0
OLE Object Data Type Question 8
Merging from an Excel file with graphics 1
Active Content in this file is blocked issue 1
Visio 2019 not able to save as Autocad .dwg file 0
OLE object doesn't show 0
Access Lock File .LACCDB / Now shows as a notepad file 0
HOW DO I CONVERT A OLE OBJECT 0

Top