Connecting To Ms Access From Progress

[Dave Hiscock]

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.

 

[Cringer]

Looks to be shortening to 8 characters. WHat if you use the tblCity one instead as a test as that is less than 8 chars?

 

[Dave Hiscock]

Thanks for the reply. I tried tblCity, but I'm still having the same issue.

 

[Dave Hiscock]

It looks like it might just be an issue with an Access 2010 database. I saved it as a 2003 database and it worked fine.