MySQL Forums
Forum List  »  Security

Add user level permissions to MS Access by using a MySQL backend
Posted by: Ankit Bansal
Date: March 24, 2015 07:44AM

I have a large Ms Access 2013 .accdb application which runs a lot of VBA code, with almost 60 users.
I developed a user level permissions mechanism using vba but now plan to migrate the back-end to MySQL community edition for enhanced speed, scalability and also explore the security available using grant permissions in MySQL. I would like to know the following:
1. Mechanism to set MySQL permissions level based on the User login in the front end login form.
2. ODBC connector details in MS Access 2013 for the above functionality.

Options: ReplyQuote


Subject
Views
Written By
Posted
Add user level permissions to MS Access by using a MySQL backend
3834
March 24, 2015 07:44AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.