Microsoft KB Archive/255122

From BetaArchive Wiki
Knowledge Base


Visio5: One or More Errors May Occur When You Create and Insert a New Visio 5.0x Drawing into a Bound Object Frame of a Microsoft Access Form

Article ID: 255122

Article Last Modified on 5/26/2005

This article was previously published under Q255122

SYMPTOMS

In Microsoft Access 95, Microsoft Access 97, or Microsoft Access 2000, you can store Visio drawings in a table. You can also use a bound object frame control to create or edit these Visio drawings from within an Access form. However, with Visio 5.0x, if you try to create a new drawing in a bound object frame from within the Access form by clicking Create From New in the Insert Object dialog box, one or more errors may appear. The following are two of the errors you may receive.

You can't insert an ActiveX control in a bound or unbound object frame. ActiveX controls are automatically contained in ActiveX control frames.

Microsoft Access can't communicate with the OLE server. The OLE server may not be registered. To register the OLE server, reinstall it.

NOTE: Visio 2000 works as expected. This issue occurs only with Visio 5.0x.

RESOLUTION

You can work around this issue in Access by inserting a Visio template or drawing into the bound object frame. You can then modify the template or drawing.

To insert a Visio template or drawing into a bound object frame:

  1. Open the Access form with the bound object frame.


NOTE: The bound object frame must be bound to an OLE Object field. If it is not, when you close the form, any work you have done is lost. If you have already created the bound object frame, you can bind it to an OLE Object field by setting the ControlSource property for the bound object frame to the name of the field.

  1. Move to the record in which you want to insert the Visio template or drawing, and then click the bound object frame.
  2. On the Insert menu, click Object.
  3. In the Insert Object dialog box, click Create From File.


NOTE: Clicking Create From New leads to the error messages described in the "Symptoms" section.

  1. For File, specify a Visio template or drawing.


If you do not know the path, click Browse, and then specify a Visio template or drawing.

  1. If you want to store any changes that you may make to the file in the original file and not in the database, click to select the Link check box.
  2. Click OK.

When you double-click the bound object frame for this record, the Visio template or drawing opens within the bound object frame. You can then modify the template or drawing.


Additional query words: you can t insert an activex control in a bound or unbound object frame

Keywords: KB255122