Bug #18514 Views in Access: In Figure A.3 of the Manual 'Read Data' has to be marked
Submitted: 26 Mar 2006 9:56 Modified: 5 Jun 2006 22:40
Reporter: Axel Borntr??ger Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Migration Toolkit Severity:S3 (Non-critical)
Version:1.0.22 Manual: revision: 1593 OS:Windows (Windows 2000)
Assigned to: Mike Hillyer CPU Architecture:Any

[26 Mar 2006 9:56] Axel Borntr??ger 
Description:
In my german Access 2000 I enabled the Administer 'Read Design' permission for both the MSysObjects and MSysQueries tables as shown in Figure A.3 of the Manual. After reverse-engineering the MTK only shows the tables and not the views.

How to repeat:
- Set only 'Read Design' permission to the system objects in Access, as shown in the Manual.
- Start the MTK.
- After reverse-enginieering there are  no views shown in the MTK.

Suggested fix:
If you additionaly set the 'Read Data' permission, the views are shown after reverse-enginieering.
[28 Mar 2006 15:34] MySQL Verification Team 
Thank you for the bug report.
[5 Jun 2006 22:40] Mike Hillyer 
In the documentation just below the screenshot you are instructed to check the Administer permission, which would have given full access. I have updated the screenshot to show the Administer box checked to further emphasize this.