Unanswered: Beating OLE containers into submission
Anyone out there with good experience with OLE container fields? I need to implement this in a 2K .mdb file and also in XP/2002.
I'm having no end of problems with them. Here's a brief summary:
1). Control.Action = acOLEClose doesn't seem to work. File does not close. Don't care if the app closes or not, but need the file to close so that I can make a copy of it.
2). Control_Updated doesn't always fire--particularly around the code = acOLEClosed.
3). User can exit field, record, form and country for that matter and leave the attached (linked) file open.
The ultimate goal is to do functional document control over the attached files. The tools MS Access gives don't seem to be adequate.