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:

Creating a Connection