ACC2000: SQL Server Security Administration Dialog Box Does Not Open (223220)


The information in this article applies to:

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

MORE INFORMATION

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.
  9. 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.

REFERENCES

For more information about securing Access projects, click Microsoft Access Help on the Help menu, type secure a Microsoft Access project in the Office Assistant or the Answer Wizard, and then click Search to view the topic.
Modification Type:MinorLast Reviewed:1/26/2005
Keywords:KbClientServer kbprb KB223220
©2004 Microsoft Corporation. All rights reserved.