Error message when you try to create a new database in Access 2007: "Template could not be instantiated"

Article translations Article translations
Article ID: 958846 - View products that this article applies to.
Expand all | Collapse all

SYMPTOMS

When you try to create a database by using a Microsoft Office Access 2007 template (.accdt) file in Access 2007, you receive an error message that resembles one or more of the following:

Error message 1
SQL Distributed Management Objects (SQL-DMO) must be on the machine running Microsoft Office Access.
Error message 2
Template 'template name' could not be instantiated. The table 'table name' could not be read from the template file. The object may be in an unrecognized format or contain invalid data.
For example, you cannot create a new database by using any of the Access 2007 templates on the Getting Started with Microsoft Office Access screen. You also cannot create a new database by using an .accdt template file that you downloaded from Microsoft Office Online.

Additionally, you cannot import a table that is in XML format into a database even if you exported the table in XML format from the same database. You do not receive an error message. However, the table is not created as expected.

CAUSE

This problem occurs if the following files are registered incorrectly:
  • Msado15.dll
  • Msadox.dll

RESOLUTION

To resolve this problem, register the Msado15.dll file and the Msadox.dll file. To register the Msado15.dll file and the Msadox.dll file, follow these steps:
  1. In Windows XP, click Start, and then click Run. In the Open box, type cmd, and then click OK.

    In Windows Vista, click Start
    Collapse this imageExpand this image
     Start button
    , and then type cmd in the Start Search box. Right-click cmd in the Programs list, and then click Run as administrator.
  2. On a computer that is running a 32-bit version of Windows, type the following command, and then press ENTER:
    cd "C:\Program Files\Common Files\System\ado"
    On a computer that is running a 64-bit version of Windows, type the following command, and then press ENTER:
    cd "C:\Program Files (X86)\Common Files\System\ado"
  3. Type the following command, and then press ENTER:
    regsvr32 msado15.dll
  4. Click OK.
  5. Type the following command, and then press ENTER:
    regsvr32 msadox.dll
  6. Type exit, and then press ENTER.

Properties

Article ID: 958846 - Last Review: March 27, 2012 - Revision: 2.0
APPLIES TO
  • Microsoft Office Access 2007
Keywords: 
kbtshoot kbprb KB958846

Give Feedback

 

Contact us for more help

Contact us for more help
Connect with Answer Desk for expert help.
Get more support from smallbusiness.support.microsoft.com