Usage Note 48849: "Not a valid password" errors occur when you read older Access database files using Access drivers with 64-bit Microsoft Office installed
When using the IMPORT procedure with DBMS=ACCESS, you might receive the following error when using 64-bit SAS
® system and 64-bit Office Access Connectivity Engine (ACE) components:
PROC IMPORT OUT= mydata
DATATABLE= "mytable
DBMS=ACCESSCS REPLACE;
DATABASE="E:\data\myolder.mdb";
SCANMEMO=YES;
USEDATE=NO;
SCANTIME=YES;
MEMOSIZE=2048;
DBPWD=XXXXXXXXX;
RUN;
ERROR: CLI error trying to establish connection: [Microsoft][ODBC Microsoft Access Driver] Not a valid password.
The problem occurs even when the password is valid and runs successfully on 32-bit machines. The problem occurs when you attempt to read an Office 95 Microsoft Access database (MDB) file. The 64-bit ACE drivers do not include the components needed to read these. To resolve the problem, resave the MDB file in a newer format, Access 2000 or later for MDB or an ACCDB for Office 2007 or later.
Operating System and Release Information
| SAS System | SAS/ACCESS Interface to PC Files | Microsoft® Windows® for x64 | 9.3 TS1M0 | |
| Microsoft Windows Server 2003 for x64 | 9.3 TS1M0 | |
| Microsoft Windows Server 2008 for x64 | 9.3 TS1M0 | |
| Windows 7 Enterprise x64 | 9.3 TS1M0 | |
| Windows 7 Professional x64 | 9.3 TS1M0 | |
| Windows 7 Ultimate x64 | 9.3 TS1M0 | |
| Windows Vista for x64 | 9.3 TS1M0 | |
*
For software releases that are not yet generally available, the Fixed
Release is the software release in which the problem is planned to be
fixed.
| Date Modified: | 2013-03-13 16:27:10 |
| Date Created: | 2013-01-07 12:57:07 |
