Re: [AccessDevelopers] Access - Word OLE Problems

I can't say what your trouble is, but I am sure anyone would discourage saving these as OLE. I don't know how many records you are talking about, but would expect that to make for an overly large and potentially troubled system. Myself, I would save only the filename and the path then use a command line call or object frame to display the selected file. I haven't done this with a Word doc but regularly handle images this way and I am sure it would work the same.

Regards, Dean

On May 18, 2011, at 10:32 AM, nealcalendar wrote:

> I have an Access table in which each record contains a Word document, stored in an OLE object field. The records are displayed in a continuous form and users open a document by double-clicking the object field, causing Word to open and display the document for viewing and editing. When viewing/editing is finished, closing the document automatically updates the OLE object. This has been working perfectly since Office 97, but appears to be broken in Office 2010.
>
> Now, when I close a document, more often than not the document is deleted from the OLE field, leaving it empty. The document is irretrievably lost from the Access record.
>
> This happens regardless of how the document is closed â€" ALT-F4; CTRL-F4; ‘File, Close and Return’; simply closing Word; pressing the Save button first â€" the result seems to be the same â€" sometimes the document is updated to the OLE field, and sometimes the OLE field is just left empty.
>
> Most of the tables are replicated, which restricts me to using Access 2000-2003 databases, but I have tried with different database versions, from 2000 to 2010, and it makes no difference.
>
> Can anyone suggest how to solve the problem without having to export everything and abandon OLE altogether?
>
>
>
>
> ------------------------------------
>
>
> Please zip all files prior to uploading to Files section.Yahoo! Groups Links
>
>
>

------------------------------------

Please zip all files prior to uploading to Files section.Yahoo! Groups Links

<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/AccessDevelopers/

<*> Your email settings:
Individual Email | Traditional

<*> To change settings online go to:
http://groups.yahoo.com/group/AccessDevelopers/join
(Yahoo! ID required)

<*> To change settings via email:
AccessDevelopers-digest@yahoogroups.com
AccessDevelopers-fullfeatured@yahoogroups.com

<*> To unsubscribe from this group, send an email to:
AccessDevelopers-unsubscribe@yahoogroups.com

<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/