ACC2000: Changes to Linked Object Do Not Update Source Properties

ID: Q208600

The information in this article applies to:
Moderate: Requires basic macro, coding, and interoperability skills.

This article applies to a Microsoft Access database (.mdb) and 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: Following the steps in this example will modify the sample database Northwind.mdb. You may want to back up the Northwind.mdb file and perform 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.

Additional query words: prb 


Keywords          : kbusage kbdta FmsOthr 
Version           : WINDOWS:2000
Platform          : WINDOWS 
Issue type        : kbprb

Last Reviewed: May 13, 1999