Qlik Community

QlikView Connectors

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

Not applicable

Memo access db field error in qlikview

Hi,

I have a mandatory field called History(memo datatype) in an access database and it shoots an error while loading the table to Qlikview.

Error: QVX_UNEXPECTED_END_OF_DATA: SQL##f - SqlState: S1000, ErrorCode: 4294966090, ErrorMsg: [Microsoft][ODBC Microsoft Access Driver] Cannot open database '|'.  It may not be a database that your application recognizes, or the file may be corrupt.


I have the latest copy of a working database and  assume it is due to the large size of data residing in that particular field per row (being a memo datatype).I am currently using an ODBC connection.Any ideas how to go about with this issue?

Any help would be highly appreciated.I am a newbie to Qlikcommunity.Thanks alot.

Regards,

Naima