OLE objects and command buttons in Access

[Guest]

Is there a way to use command buttons on a form to edit/view or add OLE
Objects? The objects are linked Word files. Would I need multiple butons or
can just one be set up to based on whether the object exists. i.e. if it's
there - edit/view, if it's not - start an add dialog?

Thanks in advance.

Joe

 

[John Nurick]

Hi Joe,

Most often it's preferable to leave the documents as files on the
network rather than to embed or link them into OLE fields. One reason is
that storing OLE objects causes the size of the database file to "bloat"
unreasonably: see http://support.microsoft.com/?id=123151 for why.

The DocMgr sample database here http://www.datastrat.com/DataStrat2.html
shows how to handle documents stored in network files.

 

[Guest]

John,
Thanks for your help, perfect examples to help me out.

Joe