Microsoft KB Archive/924737

= 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

-

APPLIES TO


 * Microsoft Office Access 2007

-





SYMPTOMS
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:

File: C__DOCUM~1_ADMINI~.MOS_MYDOCU~DATABA~1[1].AC

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.



WORKAROUND
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.



STATUS
Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the &quot;Applies to&quot; 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

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.