SYMPTOMS
The ODBC Access driver does not recognize a SYSTEM.MDA file for which the
path is longer than 29 characters.
The ODBC Access driver can be used to connect to secure Access databases.
To do this, the user should specify a SYSTEM.MDA file associated with
the Access database--by selecting the Options button in the Access
Datasource Setup dialog box, and specifying a complete path for the
SYSTEM.MDA file.
If this path is longer than 29 characters, the driver gives the following
error during SQLConnect or SQLDriverConnect:
szSqlState = '08004', *pfNativeError = -1023
szErrorMsg="[Microsoft][ODBC Single-Tier Driver][ODBC File
Library]Invalid path
For example, the following path will work for SYSTEM.MDA (it is 29
characters long):
c:\temp\snuffy1\ok\system.mda
while the following does not work (it is 30 characters long):
c:\temp\snuffy1\bad\system.mda