Cannot retrieve data from Access 2007 database

[rich_mcevoy]

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

[Anonymous]

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

[rich_mcevoy]

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

[#4]

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