ACC2000: SQL Server Security Administration Dialog Box Does Not Open

ID: Q223220

The information in this article applies to:
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.


STATUS

Microsoft has confirmed this to be a problem in the Microsoft products 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.

Additional query words: pra 


Keywords          : kbdta AccessCS 
Version           : WINDOWS:2000
Platform          : WINDOWS 
Issue type        : kbprb

Last Reviewed: May 13, 1999