Results 1 to 3 of 3
  1. #1
    journeyman is offline Advanced Beginner
    Windows 11 Access 2016
    Join Date
    Dec 2022
    Posts
    82

    OLE Word update issue

    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.

  2. #2
    moke123's Avatar
    moke123 is online now Me.Dirty=True
    Windows 11 Office 365
    Join Date
    Oct 2012
    Location
    Ma.
    Posts
    1,643
    I would ditch the ole object and just store the path to the document. Avoid the bloat.

    https://answers.microsoft.com/en-us/...9-13b6f9edaea5
    If this helped, please click the star * at the bottom left and add to my reputation- Thanks

  3. #3
    journeyman is offline Advanced Beginner
    Windows 11 Access 2016
    Join Date
    Dec 2022
    Posts
    82
    Thank you for the reply. Unfortunately, I cannot store additional documents on a separate path due to variant concerns.

    Each document is less than 100kb and small enough that Access should be able to house hundreds (if not thousands) of them.

    Thanks again, should you consider an embedded alternative I should be interested to know.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 21
    Last Post: 01-26-2022, 09:25 AM
  2. Replies: 10
    Last Post: 01-06-2022, 01:35 AM
  3. Update query issue
    By dastr in forum Queries
    Replies: 1
    Last Post: 03-28-2012, 04:39 AM
  4. HTML issue when using Word as email editor
    By dshillington in forum Programming
    Replies: 3
    Last Post: 02-14-2012, 03:28 PM
  5. Replies: 1
    Last Post: 03-18-2011, 03:22 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums