Microsoft KB Archive/208600

= ACC2000: Changes to Linked Object Do Not Update Source Properties =

Article ID: 208600

Article Last Modified on 12/12/2002

-

APPLIES TO


 * Microsoft Access 2000 Standard Edition

-



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.

