topic Re: Cannot retrieve data from Access 2007 database in QlikView

Cannot retrieve data from Access 2007 database

rich_mcevoy — Tue, 28 Aug 2012 15:56:50 GMT

I'm able to connect to my MS Access database using both the ODBC (MS Access) and OLE DB ('Microsoft Office 12 Access Database)... methods. In the wizard, I can see the list of tables within the database. However, I cannot see any fields upon selecting a table and, subsequently cannot load any data.

Here is the message I receive for the ODBC version upon 'Reload':

SQL##f - SqlState: 42000, ErrorCode: 4294965389, ErrorMsg: [Microsoft][ODBC Microsoft Access Driver] Record(s) cannot be read; no read permission on 'tblAccount'.

TestTableAccounts:

SQL SELECT *

FROM tblAccount

I checked the permissions on the Access database however there does not appear to be any restrictions. Any thoughts?

...Rich

Re: Cannot retrieve data from Access 2007 database

Anonymous — Tue, 28 Aug 2012 17:55:47 GMT

if your system is of 64 bit use (select) force -32 bit in script editor

Re: Cannot retrieve data from Access 2007 database

rich_mcevoy — Tue, 28 Aug 2012 18:14:21 GMT

Thanks for your reply. I selected 32-bit but have the same result.

Re: Cannot retrieve data from Access 2007 database

Tue, 24 Jun 2014 07:51:31 GMT

Did you solve this issue? I have a similar problem where I cannot connect to the Access DB at all. I get the same error code as you 4294965389, but with a different error message "You do not have the necessary permissions to use the '|' object. Have your system administrator or the person who created this object establish the appropriate permissions for you.

The database consist only of a linked SharePoint table/list.

Regards,

Ola