3 Replies Latest reply: Jun 24, 2014 3:51 AM by Ola Cewers RSS

    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