Linking with OLE

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?

Thanks,
K

Answer 1

Hi,

You may have to use more code than that.

Hope it helps...

Answer 2

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?

Regards,

Celeste

---

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 [e-mail].