Dave Hiscock
New Member
Hello,
I'm trying to connect to connect to an external MS Access database from within my application using the following documentation: Progress KB - How to connect to the MS Access database using the ODBC DataServer
I created a small Access Database to test with that has two small tables, tblBranch and tblCity.
When I try to add table defintions to the database, the full table name displays when in the "Select ODBC Objects" window, however, once I click OK, I get the following error:
S0002: [Microsoft][ODBC Microsoft Access Driver] The Microsoft Access database engine cannot find the input table or query '.tblBranc'. Make sure it exists and that its name is spelled correctly.
It seems to be cutting off the last character of the table name when it tries to build the definitions.
I have attached screenshots showing the selection window and the error.
Thanks.
I'm trying to connect to connect to an external MS Access database from within my application using the following documentation: Progress KB - How to connect to the MS Access database using the ODBC DataServer
I created a small Access Database to test with that has two small tables, tblBranch and tblCity.
When I try to add table defintions to the database, the full table name displays when in the "Select ODBC Objects" window, however, once I click OK, I get the following error:
S0002: [Microsoft][ODBC Microsoft Access Driver] The Microsoft Access database engine cannot find the input table or query '.tblBranc'. Make sure it exists and that its name is spelled correctly.
It seems to be cutting off the last character of the table name when it tries to build the definitions.
I have attached screenshots showing the selection window and the error.
Thanks.