Microsoft KB Archive/181496

= ACC: OLE Error After You Update a Link to an Object on Windows NT 4.0 or Windows 2000 =

Article ID: 181496

Article Last Modified on 1/22/2007

-

APPLIES TO


 * Microsoft Access 95 Standard Edition
 * Microsoft Access 97 Standard Edition

-



This article was previously published under Q181496



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



SYMPTOMS
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 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 or Microsoft Windows 2000.
 * 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 Windows 98.



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.



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. </li> On the View menu, click Datasheet view.</li> In the first record, enter a in the ID field. Then click the OLEItem field in the first record.</li> On the Insert menu, click Object.</li> In the Insert Object dialog box, click Create From File, and then click Browse.</li> 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).</li> In the Insert Object dialog box, click to select the Link check box, and then click OK.</li> On the Records menu, click Save Record.</li> On the Edit menu, click OLE/DDE Links.</li> In the Links dialog box, select doc1.doc in the Links list box. Then click Change Source.</li> 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).</li> In the Links dialog box, click Close.</li> On the Records menu, click Save Record. Note that you receive one of the error messages described in the "Symptoms" section.</li></ol>

<div class="references_section">