Microsoft KB Archive/272240

= ACC2000: NorthwindCS Wizard Does Not Create Database on SQL Server 2000 =

Article ID: 272240

Article Last Modified on 6/25/2004

-

APPLIES TO


 * Microsoft Access 2000 Standard Edition

-



This article was previously published under Q272240



Moderate: Requires basic macro, coding, and interoperability skills.

This article applies only to a Microsoft Access project (.adp).



SYMPTOMS
When you try to run the sample Access project NorthwindCS.adp for the first time on a computer that is running Microsoft SQL Server 2000, NorthwindCS.adp does not recognize SQL Server, and you see the following message:

Select a SQL Server

Please select a computer with Microsoft Data Engine (MSDE) or Microsoft SQL Server installed and running from the following dialog, and choose any database on the server.

If you wish to install MSDE or SQL Server on this machine first, press Cancel here, install MSDE or SQL Server, then reopen this project.



CAUSE
If you have the Microsoft Data Engine (MSDE) or Microsoft SQL Server 7.0 loaded, the first time that you open NorthwindCS.adp, it runs Visual Basic for Applications code and a SQL script that creates the NorthwindCS SQL Server database. However, if SQL Server 7.0 or the MSDE is not loaded, you see the dialog box that is mentioned in the &quot;Symptoms&quot; section. NorthwindCS.adp does not recognize SQL Server 2000.

For additional information about having Access 2000 projects running with SQL Server 2000, click the article number below to view the article in the Microsoft Knowledge Base:

269824 ACC2000: Incompatibility Issues Between Access 2000 Projects and SQL Server 2000



RESOLUTION
Specify the sample SQL Server database Northwind, which is installed by SQL Server 2000. To do so, follow these steps:
 * 1) Click OK in the message box. Note that the Data Link Properties dialog box appears.
 * 2) Select or enter the server name. For the local server, you can just type (local).
 * 3) In the Select the database on the server box, select Northwind.
 * 4) Click OK.

NOTE: If you have a SQL Server 7.0 server on your network, you can also specify that server and the sample Northwind database.



Steps to Reproduce the Behavior
 Install Microsoft Office 2000. Install Microsoft SQL Server 2000. Open the sample Access project NorthwindCS.adp. The default location is as follows:

\Program Files\Microsoft Office\Office\Samples\



Note that you receive the message that is mentioned in the &quot;Symptoms&quot; section of this article.

Additional query words: prb

Keywords: kbprb kbclientserver KB272240

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.