insert/replace ole object in table

[Guest]

hey everyone, i have a table that has an ole object field in which we're
storing small pdf files. these are displayed in a "preview" window on the
form. i have a button where i want the user to click it, have an open dialog
box comeup (this is done) and when they select the file, it inserts it into
the ole oject field, or replaces the one already there. i just can't figure
out how ro do it programatically.. any help on this is much appreciated!!
thanx

 

[Guest]

You may want to reconsider storing anything in OLE fields. When you use
embedding technology, this can lead to severe database bloat. You would be
much better off to store the path to your file in a text data type field. You
might want to split it up, so that you are storing the filename in one text
field, and the rest of the path in another field. Then concatenate the values
together, on-the-fly, as needed.


Tom Wickerath
Microsoft Access MVP

http://www.access.qbuilt.com/html/expert_contributors.html
http://www.access.qbuilt.com/html/search.html
__________________________________________