I have a form which has a bound image field which stores OLE objects (specifically PDF documents) in a MySQL database backend. When you use this field in the full version of Access 2007 you can right click and insert a document into the table.
However, in Access 2007 RunTime this menu is disabled. I have seen information on how to create a custom menu which will give the same functionality, albeit with a significant amount of work, but I wish to use a button to insert the object into that field instead of the menu. Regrettably I have been unable to locate any code or information which makes this process possible.
What I need is for a user to click the button, have a dialog box pop up (hopefully the same one that full Access 2007 uses when you right click and "Insert Object") for the user to select the file, take that file and add it to the bound object field in the database, thus storing the document for later retrieval as is possible in full Access 2007.
Is this possible and if so, does anyone have a suggestion for a resource which I can use to design and build this function?