Results 1 to 2 of 2
  1. #1
    Star Lounger
    Join Date
    Jan 2003
    Canberra, Australian Capital Territory, Australia
    Thanked 0 Times in 0 Posts

    OLE Object field no longer works (Access2000)

    How does the "Insert/Object" menu in Access store the Word document into an OLE Object field?

    I have just moved an Access97 database onto a new computer and converted it to Access2000. A table in the database has a OLE Object field which contains a Word document. However, when I double click on the OLE Object field it no longer opens up the document. Do I have to reinsert the documents?

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Thanked 31 Times in 31 Posts

    Re: OLE Object field no longer works (Access2000)

    I don't have an explanation or workaround for you, I just wanted to remark that I avoid the use of OLE fields. They tend to bloat the database and make it more prone to corruption. If I need to make images or documents available, I don't store them in the database itself, but leave them as external files. I store their path and file names in a text field, and use code to display the image in an image control, or to open the document in its own application.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts