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.