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 1SQL Distributed Management Objects (SQL-DMO) must be on the machine running Microsoft Office Access.
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.
This problem occurs if the following files are registered incorrectly:
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 StartCollapse this imageExpand this image
- 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"
- 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.