- \n
- Option 1: How to set and manage MDB file user-level security in Access 2010<\/a><\/li>\n
- Option 2: How to remove user-level security from MDB file in Access 2010<\/a><\/li>\n<\/ul>\n
Option 1: How to set and manage MDB file user-level security in Access 2010<\/h2>\n
Believe most of people are using Microsoft Access 2007\/2010\/2013, so we take Microsoft Access 2010 as example. But please pay attention to this, when you have MDB files with user-level security and open it in Access 2010, you cannot manage user-level security in Access 2010<\/strong> like in Access 2003.<\/p>\n
Step 1:<\/strong> Open the .mdb or .mde file that you want to administer.<\/p>\n
Start Access 2010, click File<\/strong> tab and Open<\/strong> button to browse *.mdb or *.mde file you would like to administer. When you find, select it and click open.<\/p>\n
Step 2:<\/strong> On the Database Tools<\/strong> tab, in the Administer<\/strong> group, click the arrow below Users and Permissions<\/strong>, and then click User-Level Security Wizard<\/strong>.<\/p>\n
If you found there is no Administer group in Database Tools tab, you should add Administer to Database Tools<\/strong> at first.<\/p>\n
1. Open Microsoft Access 2010.<\/p>\n
2. Click File tab and choose Options<\/strong>.<\/p>\n
![\"open](\"https:\/\/www.isunshare.com\/blog\/wp-content\/uploads\/2015\/04\/open-access-options-settings.png\")
<\/a><\/p>\n3. In Access Options window, click Quick Access Toolbar<\/strong>.<\/p>\n
![\"add](\"https:\/\/www.isunshare.com\/blog\/wp-content\/uploads\/2015\/04\/add-administer-to-database-tools.png\")
<\/a><\/p>\n4. In the right pane, customize the quick Access Toolbar.<\/p>\n
4-1 Browse Choose commands from<\/strong> list in the right pane and choose Database Tools tab<\/strong>.<\/p>\n
4-2 You would find Administer<\/strong> under “Database Tools tab”. Double click it and it will be moved from left frame to right frame.<\/p>\n
Or select “Administer” and click “Add” button. It will be in the right frame under Customize Quick Access Toolbar<\/strong>.<\/p>\n
5. Click OK to confirm changes in Access 2010 Database Tools.<\/p>\n
Step 3:<\/strong> Follow steps on each following page to complete wizard.<\/p>\n
Option 2: How to remove user-level security from MDB file in Access 2010<\/h2>\n
While you don\u2019t want MDB file protected with user-level security, you can remove user-level security from the file by saving the *mdb file as an *.accdb file while working in Access 2010. This is because that user-level security becomes unavailable after MDB file is converted to ACCDB file.<\/p>\n
1. Click the File<\/strong> tab in Access 2010.<\/p>\n
2. On the left pane, click Save Database As<\/strong>. The Save As<\/strong> dialog box appears.<\/p>\n
![\"choose](\"https:\/\/www.isunshare.com\/blog\/wp-content\/uploads\/2015\/04\/choose-to-save-database-as.png\")
<\/a><\/p>\n3. Browse computer in Save As<\/strong> window and find a location in which to save the converted database.<\/p>\n
![\"save](\"https:\/\/www.isunshare.com\/blog\/wp-content\/uploads\/2015\/04\/save-mdb-database-as-accdb-database.png\")
<\/a><\/p>\n4. In the Save as type<\/strong> list of dialog bottom, select Access 2007 Database<\/strong> (*.accdb) or Microsoft Access Database<\/strong>.<\/p>\n
5. Click Save<\/strong>.<\/p>\n
Related Articles:<\/strong><\/p>\n
- \n
- How to Set Security Level in MS Access 2010 with Security Features<\/a><\/li>\n
- How to Open Access Database Secured with User Security or User-Level Security<\/a><\/li>\n
- How to Encrypt and Decrypt Access Database<\/a><\/li>\n
- How to Open and Edit MDB File without Microsoft Access<\/a><\/li>\n
- 3 Ways to Create Access 2007-2013 Database<\/a><\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"
Once user-level security referred, we should know it is available only in *.mdb file, which is created usually…<\/p>\n","protected":false},"author":1,"featured_media":126293,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[19],"tags":[],"class_list":["post-2496","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-office-documents"],"_links":{"self":[{"href":"https:\/\/www.isunshare.com\/blog\/wp-json\/wp\/v2\/posts\/2496","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.isunshare.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.isunshare.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.isunshare.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.isunshare.com\/blog\/wp-json\/wp\/v2\/comments?post=2496"}],"version-history":[{"count":4,"href":"https:\/\/www.isunshare.com\/blog\/wp-json\/wp\/v2\/posts\/2496\/revisions"}],"predecessor-version":[{"id":6309,"href":"https:\/\/www.isunshare.com\/blog\/wp-json\/wp\/v2\/posts\/2496\/revisions\/6309"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.isunshare.com\/blog\/wp-json\/wp\/v2\/media\/126293"}],"wp:attachment":[{"href":"https:\/\/www.isunshare.com\/blog\/wp-json\/wp\/v2\/media?parent=2496"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.isunshare.com\/blog\/wp-json\/wp\/v2\/categories?post=2496"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.isunshare.com\/blog\/wp-json\/wp\/v2\/tags?post=2496"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}
- How to Open Access Database Secured with User Security or User-Level Security<\/a><\/li>\n
- Option 2: How to remove user-level security from MDB file in Access 2010<\/a><\/li>\n<\/ul>\n