Results 1 to 2 of 2
  1. #1
    escelinen is offline Novice
    Windows 7 32bit Access 2003
    Join Date
    Sep 2011

    Question Access 2003 database with password and switchboard

    my Google search didn't help so I'll ask from experts.
    I'm having problem with Access 2003 database which has tables, forms, reports, macros and automatic switchboard from startup as a menu where users can select the needed action they want to do.

    In the beginning .mdb opened directly to the switchboard but we prefer to protect the database with password from Tools -security. So nowadays it asks password before opening the switchboard.

    Now we want to set different user group levels as admin, add/change, add/read and limited read.

    But we cannot reset the main password at all because there is no Tools menu as the switchboard is hiding menu items.
    There is only File, Edit, Insert, Records, Window and Help

    How we can reset/remove the password?

    What's best way to give access or limit it depending a group?
    Is it possible to hide menu items depending your group in Access?

    Thanks a lot!


  2. #2
    apr pillai's Avatar
    apr pillai is offline Competent Performer
    Windows 7 64bit Access 2007
    Join Date
    May 2010
    Alappuzha, India
    While opening the database, after typing the password, hold on to shift key to open the database. This will not open the Switchboard and will give you a chance to open the Startup Menu and to restore the buil-in Menus and Toolbars.

    You can select Tools-->Security menu options to reset the database password.

    For User-Level security implementation you need to know about Microsoft Access Security. Visit the link: Microsoft Access Security for more details.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 7
    Last Post: 09-13-2011, 01:38 PM
  2. Password Protect button on Switchboard
    By rosaj in forum Access
    Replies: 1
    Last Post: 08-04-2011, 11:08 AM
  3. Migration from Access 2003 database to Access 2007 database.
    By cyclus2 in forum Import/Export Data
    Replies: 1
    Last Post: 09-10-2010, 11:43 AM
  4. Requested Password in new database access
    By baldo10 in forum Access
    Replies: 3
    Last Post: 09-07-2010, 04:23 AM
  5. Switchboard blank 2003 to 2007
    By Garyk545 in forum Forms
    Replies: 1
    Last Post: 07-02-2010, 11:21 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
Other Forums: Microsoft Office Forums - Senior Forums