Cannot Access Password-Protected Paradox 4.x Table (153764)
The information in this article applies to:
- Microsoft Excel for Windows 95
- Microsoft Excel for Windows 5.0
- Microsoft Query
This article was previously published under Q153764 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:
124218 Macro Examples Using XLODBC Functions
148361 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.
| Modification Type: | Minor | Last Reviewed: | 8/17/2005 |
|---|
| Keywords: | KB153764 |
|---|
|