If you drag a ms word doc from a folder directly into an access database cell whose datatype is OLE Object, you find that you have a copy of that doc in your database. Even if you deleted that document from all folders you still find that it exists independently in your database cell. You can open it and even make changes.
My problem. Instead of dragging this document into the cell is there another way I can do this using code. So that I can select a doc using showdialog and save it as ole object rather than save just it's link
Note that when I open my database and click on that cell the document opens. This is what the cell looks like when I have dragged the document into it " Microsoft Office Word 97-2003 Document"
Any help will be highly appreciated.