ACC2000: NorthwindCS Wizard Does Not Create Database on SQL Server 2000 (272240)


The information in this article applies to:

  • Microsoft Access 2000
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 "Symptoms" 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.

MORE INFORMATION

Steps to Reproduce the Behavior

  1. Install Microsoft Office 2000.
  2. Install Microsoft SQL Server 2000.
  3. 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 "Symptoms" section of this article.
Modification Type:MajorLast Reviewed:6/25/2004
Keywords:KbClientServer kbprb KB272240
©2004 Microsoft Corporation. All rights reserved.