Article ID: 958846 - 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
Error message 2
SQL Distributed Management Objects (SQL-DMO) must be on the machine running Microsoft Office Access.
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.
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.
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:
Contact us for more help
Connect with Answer Desk for expert help.