Microsoft Knowledge Base Article
This article contents is Microsoft Copyrighted material.
©2005-©2007 Microsoft Corporation. All rights reserved.
Terms
of Use |
Trademarks
Article ID: 223220 - Last Review: January 26, 2005 - Revision: 1.2
ACC2000: SQL Server Security Administration Dialog Box Does Not Open
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).
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.
The MSDE installs the Database Security tools.
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.
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
-
Set up a clean Windows 95/98 computer with a network connection.
-
Install Microsoft Office 2000 on the computer.
- Open Access 2000. In the Microsoft Access startup dialog box, click to select Access database wizards, pages, and projects. Click OK.
-
In the New dialog box, click the General tab and click Project (Existing Database). Click OK.
- In the File New Database dialog box, type the name, MyTest, and click Create.
- 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.
- Select the appropriate security and enter a valid user name and password.
- 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. - 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.
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.
APPLIES TO
- Microsoft Access 2000 Standard Edition
| kbprb kbclientserver KB223220 |
Community Feedback System
Very often, it takes hours to solve a problem. Very often, you've looked high
and low, and have tried a lot of solutions. When you finally found it, chances
are, it was because someone else helped you. Here's your chance to give back.
Use our community feedback tool to let others know what worked for you and what
didn't.
Please also understand that the community feedback system is not warranted to be
correct, it's simply a system that we've built to let people try and help each
other. If something in a feedback response doesn't make sense to you, or you're
not comfortable making changes that the feedback talks about (like registry
edits), please consult a professional.
Thank you for using kbAlertz.com Feedback System.
-- Scott Cate