Notice: This website is an unofficial Microsoft Knowledge Base (hereinafter KB) archive and is intended to provide a reliable access to deleted content from Microsoft KB. All KB articles are owned by Microsoft Corporation. Read full disclaimer for more details.
Error message when you try to create a new database in Access 2007: "Template could not be instantiated"
View products that this article applies to.
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
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.
Error message 1
SQL Distributed Management Objects (SQL-DMO) must be on the machine running Microsoft Office Access.
Error message 2Template '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.
This problem occurs if the following files are registered incorrectly:
- Msado15.dll
- Msadox.dll
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:
- In Windows XP, click Start, and then click Run. In the Open box, type cmd, and then click OK.
In Windows Vista, click Start
, and then type cmd in the Start Search box. Right-click cmd in the Programs list, and then click Run as administrator. - On a computer that is running a 32-bit version of Windows, type the following command, and then press ENTER: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"
- Type the following command, and then press ENTER:regsvr32 msado15.dll
- Click OK.
- Type the following command, and then press ENTER:regsvr32 msadox.dll
- Type exit, and then press ENTER.
Keywords: kb, kbprb, kbtshoot, kbentirenet