Open document for readonly when alreayd open.

Posted on 2005-04-26
Last Modified: 2013-12-18
Right now when a user opens one of my documents that has an embedded spreadsheet in it, I have it lock the document so on one else can open it and edit it. -- I would like it so the first person in is the only one that can edit the embedded object but everyone else can still get into the document and read the OLE object. Any idea's?

Thanks in advance for help.
Question by:unknown45
    1 Comment
    LVL 31

    Accepted Solution

    You have a weird interaction of the Notes UI and the OLE object UI.  In order to save an update to an OLE object, the OLE container (Notes) must receive the update from the OLE editor (Excel) and store that update.  The way this works in Notes i:

    1) Excel saves update
    2) Notes editor recieves update
    3) Notes editor updates in-memory copy of object with OLE data
    4) When editor saves document, then OLE chnages are also saved to database.

    Until step 4 happens, the OLE adta is really not saved at all, in any permanent way.  And since, from what you say, the document is locked and can't be saved to the database, the OLE update will not really be saved at all.

    Now, that fulfills your requirements half-way -- the OLE object can be edited, and can appear to be saved (step 1 of 4), but it can't actually be saved.  What you really want is to prevent anyone from editing the object in teh OLE editor at all.  Unformtunately, that's controlled by the OLE editor, not by Notes, and there's little you can do about it.

    Featured Post

    How your wiki can always stay up-to-date

    Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
    - Increase transparency
    - Onboard new hires faster
    - Access from mobile/offline

    Join & Write a Comment

    For users on the Lotus Notes 8 Standard client, this article provides information on checking the Java Heap size and adjusting it to half of your system RAM in attempt to get the Lotus Notes 8.x Standard client to run faster.  I've had to exercise t…
      In today’s Arena we can’t imagine our lives without Internet as we are highly used to of it. If we consider our life style just for only 2 min we found that face to face communication is swapped by e-communication.  Every Where from Works place to…
    Illustrator's Shape Builder tool will let you combine shapes visually and interactively. This video shows the Mac version, but the tool works the same way in Windows. To follow along with this video, you can draw your own shapes or download the file…
    Get a first impression of how PRTG looks and learn how it works.   This video is a short introduction to PRTG, as an initial overview or as a quick start for new PRTG users.

    729 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    22 Experts available now in Live!

    Get 1:1 Help Now