I'm aware of how to usually link/embed an OLE object to an OLE object field (Insert -> Object etc.) but would it be possible to do the same through a programmed SQL query? I've tried it by simply passing the path of the file I want to link to an INSERT or UPDATE query, but that results in the field displaying "long binary data" and being inaccessible.
Reason why I want to know is that in my application I want to minimize and if possible eliminate the user's ability to use Access' regular menu options, but the specs demand that users must be able to embed .PDF files in records. Is there an SQL or otherwise programmable solution available to me that won't require me to leave Access' normal menu options open?
(Version used, if it makes a difference, is Access 2003, but the database app is in Access 2000 format.)
"Any fool can defend his or her mistakes; and most fools do." -- Dale Carnegie
Reason why I want to know is that in my application I want to minimize and if possible eliminate the user's ability to use Access' regular menu options, but the specs demand that users must be able to embed .PDF files in records. Is there an SQL or otherwise programmable solution available to me that won't require me to leave Access' normal menu options open?
(Version used, if it makes a difference, is Access 2003, but the database app is in Access 2000 format.)
"Any fool can defend his or her mistakes; and most fools do." -- Dale Carnegie
