Microsoft KB Archive/924737

From BetaArchive Wiki
Knowledge Base

You receive an error message when you try to open an Access 2007 database file that is stored in an Access 2007 OLE Object field

Article ID: 924737

Article Last Modified on 10/15/2007


  • Microsoft Office Access 2007


When you double-click an OLE Object field in a Microsoft Office Access 2007 database table to try to open an Access 2007 database file, you receive an error message that resembles the following:

Windows cannot open this file:
To open this file, Windows needs to know what program created it. Windows can go online to look it up automatically, or you can manually select from a list of programs on your computer.


To work around this problem follow these steps:

  1. Select the field that contains the Access 2007 database file that you want to open.
  2. Right-click the field, click Package Object, and then click Edit Package.
  3. Select the Access 2007 database file icon in the left pane, and then click Save Contents on the File menu.
  4. Type the name of the Access 2007 database file in the File name text box, and then click Save.


Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.

Steps to reproduce the problem

  1. In an Access 2007 database, click the Create tab, and then click Table.
  2. Press CTRL+S, type OLETable in the Table Name box, and then click OK.
  3. Right-click OLETable: Table in the Navigation Pane, and then click Design View.
  4. Type MyOLEFiled in the Field Name column, select OLE Object in the Data Type column, and then press CTRL+S to save the changes.
  5. Right-click OLETable: Table in the Navigation Pane, and then click Open.
  6. Select the MyOLEField field, right-click the selected field, and then click Insert Object.
  7. Click Create from File, and then click Browse.
  8. Locate and then select an Access 2007 database file that has an .accdb file name extension. Then, click OK.
  9. Click OK in the Microsoft Office Access dialog box to add the database file to the field.
  10. Double-click the MyOLEField field that contains the inserted database file.

Additional query words: AC2007 ACC2007 Access2007

Keywords: kberrmsg kbtshoot kbbug kbdatabase kbprb kbopenfile kbexpertiseinter KB924737