All,
This may be an advanced issue. I have a linked table to a BE db. Most fields in this table ([Documents]) are standard text and numeric.
One field is of data type OLE Object. This field contains a small embedded word document. This document is embedded by copying a OLE control from another table into the this [Documents] table
e.g (excusing declarations, etc)
Code:
Rs2!EmbeddedDocument = Rs1!BaseDocument
The idea was that the user could click a popout button which presented the document in a word instance.
This generally worked - at least when I first designed the solution, but now whenever I edit the word document in it's own instance, then close it and try to move to another record, I am receiving an error message
Could not update; currently locked by another session on this machine.
This is very clearly wrong. I am the only person in the record. There is no other process running.
Interestingly, this issue did not present when the DB was not split.
It would appear that the OLE modifications no longer save when the windows instance is closed - and does not reset the record. WHY??
Help appreciated. many thanks in advance.