Knowledge Base

ACC: Changes to Linked Object Do Not Update Source Properties

Article ID: 141884

Article Last Modified on 1/19/2007

APPLIES TO

This article was previously published under Q141884

SYMPTOMS

If you change the source of a linked object on a form by using the Links dialog box, the SourceDoc and SourceItem properties for that object are not updated although the object itself is updated correctly.

CAUSE

The SourceDoc and SourceItem properties are not designed to reflect changes to an object's current source. These properties display their source when you create new objects. When you update existing objects through the user interface or programmatically through Visual Basic for Applications, the SourceDoc and SourceItem properties will not reflect the fact that the object has been changed to point to a file other than the original source.

MORE INFORMATION

Steps to Reproduce Behavior


  1. Open the sample database Northwind.mdb and create a new form not based on any table or query.
  2. On the Insert menu, click Object.
  3. In the Insert Object dialog box, click Create From File.
  4. Click the Browse button, click to select any bitmap file in the Windows main folder, and then click Open (or OK in Microsoft Access 7.0).
  5. Click to select the Link check box, and then click OK.
  6. On the Edit menu, click OLE/DDE Links.
  7. Click to select the bitmap listed in the Links box and click the Change Source button.
  8. In the Change Source dialog box, select a different bitmap file from the Windows main folder (a bitmap file other than the file you originally selected), and then click Open (or OK in Microsoft Access 7.0).
  9. Click Close. Note that the linked object on the form is updated. When you view the object's properties, however, note that the SourceItem property is blank and that the SourceDoc property continues to point to the bitmap file that you originally selected.

REFERENCES

For more information about links, search the Help Index for "Linked Objects, Creating and Inserting," and then "Add a picture or other object to a form or report," or ask the Microsoft Access 97 Office Assistant.

For more information about SourceDoc, search the Help Index for "SourceDoc Property," or ask the Microsoft Access 97 Office Assistant.

Keywords: kbprb kbusage KB141884


Send feedback to Microsoft

© Microsoft Corporation. All rights reserved.