MSQUERY: Cannot Access Password-Protected Paradox 4.x Table

ID: Q153764

1.00 2.00 WINDOWS kbtool kberrmsg

The information in this article applies to:

SYMPTOMS

When you are using Microsoft Query version 1.0 and the Paradox 4.x ODBC driver version 2.00.2317, you may receive the following error message:

   Couldn't Decrypt File.

When you are using Microsoft Query version 2.0 and the Paradox 4.x ODBC driver version 3.00.2111, you may receive the following error message:

   Can't access table '<path>\table.db'.

CAUSE

Using Microsoft Query, you may be unable to access Paradox 4.x tables that are password protected.

WORKAROUND

To workaround this problem so that the table can be used in Microsoft Query, remove the password protection from the table.

There are also alternative methods that will allow you to access the data without using Microsoft Query. For example, you can successfully access password-protected Paradox 4.x tables with Microsoft Excel macros that use either data access objects (DAO) or the Xlodbc.xla functions.

For additional information, please see the following articles in the Microsoft Knowledge Base:

   ARTICLE-ID: Q124218
   TITLE     : XL5: Macro Examples Using XLODBC Functions

   ARTICLE-ID: Q148361
   TITLE     : XL7: Visual Basic Example to Open a RecordSet Using DAO

STATUS

Microsoft has confirmed this to be a problem in the Microsoft products listed at the beginning of this article. Microsoft is researching this problem and will post new information here in the Microsoft Knowledge Base as it becomes available.

Paradox is manufactured by Borland International, Inc., a vendor independent of Microsoft; we make no warranty, implied or otherwise, regarding this product's performance or reliability.

KBCategory: kbtool kberrmsg kb3rdparty KBSubcategory: xlwin

Additional reference words: 2.00 1.00 Secure Security

Keywords          : xlwin 
Version           : 1.00 2.00
Platform          : WINDOWS

Last Reviewed: March 1, 1997