Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Not applicable

Microsoft Access Connection to Qlik Sense Desktop

Hello,

Whenever I try to load my newly updated Microsoft Access database on Data manager, this is what I always see.

The following error occurred:

QVX_UNEXPECTED_END_OF_DATA: SQL##f - SqlState: S1001, ErrorCode: 4294966285, ErrorMsg: [Microsoft][ODBC Microsoft Access Driver] System resource exceeded.

Would anybody know how to fix it?

Thank you,

2 Replies
Not applicable

Re: Microsoft Access Connection to Qlik Sense Desktop

there is Microsoft 32 bit Access ODBC drivers and 64 bit ODBC drivers , check with ur access DB system 32 bit or 64 bit, reinstall drives, may be there is User access issues with MS Access DB, check your user privileges 

Not applicable

Re: Microsoft Access Connection to Qlik Sense Desktop

Hi Srinivas,

I have been using the 32 bit Access ODBC before, and it has been working fine. The only time it didnt work is when I created an expression on design view of Access, and tried to include it and load it on Qlik

The expression I created on the query is working smoothly, it's just when I try to load that field that is causing the issue