DOCTYPE
MS Access Permissions
In order for DbWrench to reverse engineer a Microsoft Access database certain read permissions must be granted on the system tables of that database.
To Set the Permissions:
In Access, open the database you wish to connect to.
Click on the menu: Tools -> Security -> User and Group Permissions.
Enable 'Read Design' and 'Read Data' For MSysObject and MSysRelationships for the user specified in the connection.
Read Design and Read Data Permissions Enabled
MSys Tables not
Available
The User and Group Permissions window may not list MSys System tables. They can be listed by doing the following.
Click on the menu: Tools -> Options.
Ensure System objects is enabled in the View tab.
Setting View Options
See also: