ACC2000: Changes to Linked Object Do Not Update Source Properties (208600)


The information in this article applies to:

  • Microsoft Access 2000
This article was previously published under Q208600
Moderate: Requires basic macro, coding, and interoperability skills.

This article applies to a Microsoft Access database (.mdb) and to a Microsoft Access project (.adp).

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 do not reflect the fact that the object has been changed to point to a file other than the original source.

MORE INFORMATION

CAUTION: If you follow the steps in this example, you modify the sample database Northwind.mdb. You may want to back up the Northwind.mdb file and follow these steps on a copy of the database.

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.
  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 that you originally selected), and then click Open.
  9. Click Close.

    Note that the linked object on the form is updated.
However, upon viewing the object's properties, you see 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 linking to objects, click Microsoft Access Help on the Help menu, type Add an unbound object to a form or report in the Office Assistant or the Answer Wizard, and then click Search to view the topic.

For more information about the SourceDoc property, click Microsoft Access Help on the Help menu, type SourceDoc property in the Office Assistant or the Answer Wizard, and then click Search to view the topic.
Modification Type:MajorLast Reviewed:12/12/2002
Keywords:kbdta kbprb kbusage KB208600
©2002 Microsoft Corporation. All rights reserved.