Linking with OLE RRS feed

  • Question

  • hi,

    I'm using just two lines of code to attach pictures etc. using OLE.

        Me.oleAttachment.OLETypeAllowed = acOLEEmbedded
        Me.oleAttachment.Action = acOLEInsertObjDlg

    I'm getting this error when i try to attach document | picture (Pic 1 below)

    I'm also getting error when i click the OLE object and then try to lose focus away from the field (Pic 2 below)

    I've a linked SQL Server back-end. Am I using the most efficient way to attache picture(s) | Word | Excel documents, etc. in my scenarios, or is there a better way to do so please?

    If this is the most efficient way, how could i resolve above issues please?


    • Edited by KhurramKZ Friday, August 25, 2017 11:00 AM
    Friday, August 25, 2017 10:57 AM

All replies

  • Hi,

    You may have to use more code than that.

    Hope it helps...

    Friday, August 25, 2017 2:44 PM
  • Hello,

    Does the link shared by theDBguy help? Could you manually insert ole object in Access? Would you get any error?

    What data type do you use in SQL Server for the ole object field?



    MSDN Community Support
    Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact MSDNFSF@microsoft.com.

    Monday, August 28, 2017 6:09 AM