Microsoft KB Archive/223220

= ACC2000: SQL Server Security Administration Dialog Box Does Not Open =

Article ID: 223220

Article Last Modified on 1/26/2005

-

APPLIES TO


 * Microsoft Access 2000 Standard Edition

-



This article was previously published under Q223220



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

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



SYMPTOMS
In Access 2000, if you have not installed the Microsoft Data Engine (MSDE), you can still create Microsoft Access projects and connect to Microsoft SQL Server databases on other computers through a network connection; however, the dialog box for database security is not available. When you try to access the database security by pointing to Security and clicking Database Security on the Tools menu, you see the following message:

The database administrative components failed to load or initialize. Verify that the components are installed and registered locally.



CAUSE
The MSDE installs the Database Security tools.



RESOLUTION
Install MSDE, and then restart the computer. You can find the Setup program, SetUpSQL.exe, on the first Microsoft Office CD in the \SQL\x86\Setup\ folder.

With SQL Server 2000 installed, you cannot manage security from an Access project until you install the SQL Server 2000 Client Tools, which includes Query Analyzer and Enterprise Manager. The client tools must be installed on each development computer on which you want to manage security. You can insall the client tools by running SQL Server 2000 Setup.



STATUS
Microsoft has confirmed that this is a problem in the Microsoft products that are listed at the beginning of this article.



Steps to Reproduce Behavior

 * 1) Set up a clean Windows 95/98 computer with a network connection.
 * 2) Install Microsoft Office 2000 on the computer.
 * 3) Open Access 2000. In the Microsoft Access startup dialog box, click to select Access database wizards, pages, and projects. Click OK.
 * 4) In the New dialog box, click the General tab and click Project (Existing Database). Click OK.
 * 5) In the File New Database dialog box, type the name, MyTest, and click Create.
 * 6) In the Select or enter a server name box of the Data Link Properties dialog box, enter the name of a computer on your network running Microsoft SQL Server.
 * 7) Select the appropriate security and enter a valid user name and password.
 * 8) In the Select the database on the server box, select the pubs database and click OK.

The new Access project for the pubs database appears.
 * 1) On the Tools menu, point to Security, and then click Database Security.

Note that you receive the error described in the "Symptoms" section of this article.

