ACC2002: Error Importing XML Files into Microsoft Access Projects (ADPs) (275328)

SYMPTOMS

When you import an Extensible Markup Language (XML) file into a Microsoft Access project (.adp), you may receive one of the following error messages:

Microsoft SQL Server Desktop Engine must be on the machine running Microsoft Access.

-or-

[Microsoft][ODBC SQL Server Driver][SQL Server]You must upgrade your SQL Enterprise Manager and SQL-DMO (SQLOLE) to SQL Server 2000 (SQLDMO) to connect to this server.

CAUSE

This behavior can occur if your computer does not have either the same version of Microsoft SQL Server installed that you are importing the files from, or does not have any version of SQL Server installed. In this case, "Microsoft SQL Server" refers to any version of SQL Server, Microsoft SQL Server 2000 Desktop Engine, or Microsoft Database Engine (MSDE).

RESOLUTION

To resolve this issue, install the same version of SQL Server, SQL Server 2000 Desktop Engine, or MSDE on the local computer.

For additional information about installing Microsoft SQL Server 2000 Desktop Engine, click the article number below to view the article in the Microsoft Knowledge Base:

290627 ACC2002: Microsoft SQL Server 2000 Desktop Engine Is Not Installed by Office XP Setup

For additional information about installing the MSDE, click the article number below to view the article in the Microsoft Knowledge Base:

218812 ACC2000: Microsoft Data Engine (MSDE) Is Not Installed by Office 2000 Setup

MORE INFORMATION

Manipulation of SQL Server data structures, such as tables, requires that both the client and the server computers have the same set of SQL Distributed Management Objects (SQL-DMO). SQL-DMO is installed at the same time that you install SQL Server 2000 (including SQL Server 2000 Desktop Engine). This issue can occur as a result of the fact that SQL-DMO present with Microsoft SQL Server 7.0 and MSDE is an earlier version, and does not expose all elements of a SQL Server 2000 database. If this is the case, you need to upgrade the client version of SQL-DMO to be fully compatible with that of the server.

Steps to Reproduce the Problem

Ensure that no version of SQL Server or MSDE is installed on your computer.

Copy and paste the following XML code to Notepad, and then save it as Test.xml:

<?xml version="1.0" encoding="UTF-8"?>
<dataroot xmlns:od="urn:schemas-microsoft-com:officedata">
<Shippers>
<ShipperID>1</ShipperID>
<CompanyName>Speedy Express</CompanyName>
<Phone>(503) 555-9831</Phone>
</Shippers>
</dataroot>

Create a new Microsoft Access project connected to the Northwind database, located on a remote SQL Server computer.
On the File menu, point to Get External Data, and then click Import.
In the Import dialog box, select the Test.xml file that you created in step 2, and then click Import.
In the Import XML dialog box, click OK. Note that you receive the first error message listed in the "Symptoms" section of this article.