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 INFORMATIONSteps 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
|