ACC: OLE Error After Updating Link to OLE Object on NT 4.0

ID: Q181496

The information in this article applies to:

Microsoft Access versions 7.0, 97

SYMPTOMS

Moderate: Requires basic macro, coding, and interoperability skills.

When you try to commit a record after you have edited an OLE Link, you may receive one of the following error messages.

In Microsoft Access version 7.0
-------------------------------

The object application isn't registered.

Solution
To register the object application, reinstall it.

In Microsoft Access 97
----------------------

The OLE server isn't registered.

To register the OLE server, reinstall it.

You may also receive the following error in Microsoft Access 7.0 or 97:

An application error has occurred
and an application error log is being generated.

MSACCESS.exe
Exception: access violation (0xc0000005)

CAUSE

This problem occurs if both of the following conditions are true:

You are running Microsoft Windows NT 4.0.

When you updated the link in the Change Source dialog box, you typed only the name of the file instead of the full path to the file in the File Name box.

Note that this behavior does not occur if you are running Microsoft Windows 95 or later.

RESOLUTION

There are two ways to work around this problem:

In the Change Source dialog box, select the new file by clicking it in the list under the File Name box.

-or-

Type the full path to the new file in the File Name box.

STATUS

Microsoft has confirmed this to be a problem in Microsoft Access 7.0 and 97.

MORE INFORMATION

Steps to Reproduce Behavior

On a computer running Microsoft Windows NT 4.0, start Microsoft Word.

Create two documents, doc1.doc and doc2.doc, in the same folder. Then quit Microsoft Word.

Start Microsoft Access and create a new database.

Create the following table:


       Table: tblOLETest
       ----------------------------
       Field Name: ID
          Data Type: Text
       Field Name: OLEItem
          Data Type: OLE Object

       Table Properties: tblOLETest
       ----------------------------
       PrimaryKey: ID

     Save the table as tblOLETest.

On the View menu, click Datasheet view.

In the first record, enter a in the ID field. Then click the OLEItem field in the first record.

On the Insert menu, click Object.

In the Insert Object dialog box, click Create From File, and then click Browse.

In the Browse dialog box, select the doc1.doc file that you created in step 2. Then click Open (or click OK if you are using Microsoft Access 7.0).

In the Insert Object dialog box, click to select the Link check box, and then click OK.

On the Records menu, click Save Record.

On the Edit menu, click OLE/DDE Links.

In the Links dialog box, select doc1.doc in the Links list box. Then click Change Source.

In the Change Source dialog box, delete the contents of the File Name box and type doc2.doc. Click Open (or click OK if you are using Microsoft Access 7.0).

In the Links dialog box, click Close.

On the Records menu, click Save Record. Note that you receive one of the error messages described in the "Symptoms" section.

REFERENCES

For more information about links to OLE objects, search the Help Index for "OLE objects, reconnecting links" and display the topic "Reconnect a link to an object on a form or report."

Additional query words: pra message


Keywords          : kbdta IntpOle 
Version           : WINDOWS:7.0,97
Platform          : WINDOWS 
Issue type        : kbbug

Last Reviewed: April 19, 1999