Inserting Word Documents into Access
I am trying to write a script (VBA) to mass update an existing table with a Blob field of Word Documents. I have the code setup to compare the document's last update date with the one in the table (a field for last date), then if the dates do not match, copy the document and insert it into the Blob Field. I have tried to copy the document as a OLE embedded source into a unbounded Object Frame, then copy this to the clipboard then paste to a Bound Object Frame. Finally, I set the field equal to the Bound Object Frame. Unfortunately, this doesn't work very well. Any suggestions?