I've set up a "MyTemp" alias to which I wish to assign a variety of different MS Access tables at run-time based on a user selection which changes the Parameter for Database Name to the required value. The parameter list for the selected Database Alias is then displayed as a check.
However, when I try to retrieve the table names from the Database I get an EDBEngineError with the message
"General SQL error. [Microsoft][ODBC Microsoft Access Driver]Invalid connection string attribute DATABASE Alias:MyTemp"
The connection string within the BDE is fine.
However, I've deliberately left the Database name in ODBCADM empty (to enable the user selection facility) and I think this is where the problem is - anyone know how to set this (temporarily)?
However, when I try to retrieve the table names from the Database I get an EDBEngineError with the message
"General SQL error. [Microsoft][ODBC Microsoft Access Driver]Invalid connection string attribute DATABASE Alias:MyTemp"
The connection string within the BDE is fine.
However, I've deliberately left the Database name in ODBCADM empty (to enable the user selection facility) and I think this is where the problem is - anyone know how to set this (temporarily)?
