ACC2000: Cannot use Encrypt/Decrypt command in Microsoft Access Project (231173)


The information in this article applies to:

  • Microsoft Access 2000
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.
Modification Type:MajorLast Reviewed:3/14/2005
Keywords:KbClientServer kbprb KB231173
©2004 Microsoft Corporation. All rights reserved.