Microsoft KB Archive/231173

= ACC2000: Cannot use Encrypt/Decrypt command in Microsoft Access Project =

Article ID: 231173

Article Last Modified on 3/14/2005

-

APPLIES TO


 * Microsoft Access 2000 Standard Edition

-



This article was previously published under Q231173



Novice: Requires knowledge of the user interface on single-user computers.

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



SYMPTOMS
In a Microsoft Access project, the Encrypt/Decrypt Database command is not available (on the Tools menu, point to Security).



CAUSE
Unlike Microsoft Jet (.mdb) databases, Access projects may not be encrypted or decrypted. Therefore, the Encrypt/Decrypt Database command is not available while you work in an Access project.



MORE INFORMATION
If you want to encrypt the data that is sent and received, you can do this through the Data Link Properties dialog box. To do this, follow these steps:
 * 1) On the File menu, click Connection.
 * 2) In the Data Links Properties dialog box, click the All tab.
 * 3) Manually set the Use Encryption for Data property to true.

For additional information, visit the following Microsoft Developer Network (MSDN) Web site:

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/off2000/html/acconAboutOLEDBDataLinks.asp

Steps to Reproduce Behavior

 * 1) In Microsoft Access, open any Access project connected to a SQL Server or MSDE database.
 * 2) On the Tools menu, point to Security.
 * 3) Note that the Encrypt/Decrypt Database command is not available.

Additional query words: prb can t cannot

Keywords: kbprb kbclientserver KB231173

-

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

© Microsoft Corporation. All rights reserved.