Troubleshooting
Problem
When try to import a MS Access data source via ODBC into Framework Manager, an error occurs indicating missing permissions of the user trying to access the database. [Error:
QE-DEF-0177 An error occurred while performing operation 'sqlPrepareWithOptions'. UDA-SQL-0129 Invalid login information was detected by the underlying database. [Microsoft][ODBC Microsoft Access Driver] Record(s) cannot be read; no read permission on 'MSysRelationships'. QE-DEF-0301 SQL statement: {SELECT C.szObject, C.szColumn, C.szReferencedObject, C.szReferencedColumn, C.icolumn, C.grbit, C.szRelationship FROM MSysRelationships C ORDER BY C.szRelationship, C.icolumn }
]
Cause
In Microsoft Access special permissions to MySysXXXXX tables need to be granted to the account accessing the
database. If those are lacking, the retrieval of data fails.
Environment
Query DB: MS Access via ODBC
Resolving The Problem
Grant the user accessing the access database the necessary permissions for the system table "MSysRelationships".
Steps:1. In Access open the MS Access database.
2. From the Tools menu select Options.
3. Go to the View tab and check the (Show) System Objects check box.
4. From the Tools menu select Security/User and Group Permissions.
5. Go to the Permissions tab.
6. In the List radio group, select Users (default).
7. In the Object Type list, select Table (default).
8. In the User/Group Name list, select the user you logged as into the database as (usually Admin).
9. In the Object Name list, select the MSysRelationships
table.
10. Check the Read Data check box in the Permissions group.
Key Words: Access ODBC MSysRelationships
Was this topic helpful?
Document Information
Modified date:
15 June 2018
UID
swg21338609