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

View products that this article applies to.

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.

Back to the top

WORKAROUND

To work around this problem follow these steps:

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

Back to the top

STATUS

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

Back to the top

Steps to reproduce the problem

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