Microsoft KB Archive/314297

= PRJ2000: How to Open an MSDE-Hosted Microsoft Project Central Database in Microsoft Access =

Article ID: 314297

Article Last Modified on 1/31/2007

-

APPLIES TO


 * Microsoft Project 2000 Standard Edition

-



This article was previously published under Q314297



SUMMARY
When you use a Microsoft Data Engine (MSDE) database to host a Microsoft Project Central database, you may be unable to open the database.

This article explains how to open your MSDE-hosted Microsoft Project Central database in Microsoft Access. This configuration also allows you to edit the Microsoft Project Central database.



MORE INFORMATION
To open the Microsoft Project Central database in Microsoft Access, follow these steps:  Quit all running programs. Start Microsoft Access. Click Cancel in the Microsoft Access dialog box that appears. On the File menu, click New. Click Project (Existing Database), and then click OK. In the File name box, type the file name that you want (for example, ProjectCentral ), and then click Create. In the Data Link Properties dialog box that appears, type the name of the MSDE server in the Select or enter a server name box. To determine the name of the database server, follow these steps:  In the status area of the taskbar, right-click the MSSQLServer icon, and then click Open SQL Server Service Manager on the shortcut menu that appears.

NOTE: If the MSSQLServer icon is not displayed on the taskbar, click Start, point to Programs, point to MSDE, and then click Service Manager.</li> In the Server list, note the name of the MSDE server.</li> Close the SQL Server Service Manager dialog box.</li></ol> </li> Do one of the following: <ul> Click Use Windows NT Integrated security.

-or-</li> Click Use a specific user name and password. In the User name box, type sa. If you have created a password for the sa account, click to clear the Blank password check box, and then type the password in the Password box.</li></ul> </li> In the Select the database on the server list, select Project_CentralDB, and then click Test Connection.

NOTE: Project_CentralDB is the default database that is created when you install Microsoft Project Central. However, if you manually created a database with a different name by running the SQL scripts from the Microsoft Project Central CD-ROM, select it instead.</li> Click OK in response to the &quot;Test connection succeeded&quot; message that appears, and then click OK.

The Microsoft Project Central tables are opened in Microsoft Access.</li></ol>

Keywords: kbhowto kbinfo KB314297

-

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

© Microsoft Corporation. All rights reserved.