I'm trying to connect to Ms Access database throug webfocus using the ODBC/Ms Access adapter connection. But since the MS access file is in a ".accdb" file format when testing the adapter conneciton I'm getting the following message.
FOC1394) CONNECT FAILURE
(FOC1400) SQLCODE IS -1028 (HEX: FFFFFBFC)
: [S1000] [Microsoft][ODBC Microsoft Access Driver] Cannot open database '
: (unknown)'. It may not be a database that your application recognizes,
: or the file may be corrupt. [IM006] [Microsoft][ODBC Driver Manager] Dri
: ver's SQLSetConnectAttr failed
(FOC1405) SQL PREPARE ERROR.
Any one have idea abot this or any alternative exist ? if I select the ".mdb" format which is MS Access 2003/2007 format I'm able to connect acess the data.