Results 1 to 3 of 3

how do i strip my db of 2003 user level permissions?

  1. #1
    BobW2961 is offline Novice
    Windows 7 64bit Access 2010 64bit
    Join Date
    May 2016
    Posts
    8

    how do i strip my db of 2003 user level permissions?

    My back-end is a 2003 database with user level permissions. In the last few years, I have updated my front-end to and accdb file. The shortcut that opens the accdb front end has a switch that points to the workgroup file that was used when the database was first developed with access 2003. So when the front end accdb files opens, it asked for username and password. Once open, buttons are visible or not visible based off of username.

    I feel like I need to start working on my database to get rid of the user level permissions before a new version of access does not allow them to work at all.

    I want to make a copy of my back end and front end and start working on them to remove the user level permissions.


    How can I strip the user level permissions from both so that my database opens with out pointing to a workgroup file and it doesnt ask for username and password?

  2. #2
    June7's Avatar
    June7 is offline VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    42,645
    Bing: MS Access remove user permissions

    Does this help https://support.office.com/en-us/art...e-5d2ef79439fa
    To provide db: Make copy, remove confidential data, run compact & repair, zip w/Windows Compression if over 500KB (2MB zip allowed), attach to post. Attachment Manager is below the Advanced post editor window, click Go Advanced below the Quick Reply window.
    If any suggestion resolves your issue, please use the Thread Tools dropdown above first post and mark as Solved!

    Debug!Debug!Debug! http://www.cpearson.com/excel/debug.htm

  3. #3
    BobW2961 is offline Novice
    Windows 7 64bit Access 2010 64bit
    Join Date
    May 2016
    Posts
    8
    Perfect ! Thanks

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

Similar Threads

  1. Security for 2013 like User & Permissions in 2003
    By Squirrel1804 in forum Security
    Replies: 3
    Last Post: 01-26-2017, 03:30 PM
  2. Replies: 5
    Last Post: 07-08-2015, 01:24 PM
  3. Replies: 13
    Last Post: 07-16-2014, 09:32 AM
  4. Strip Security from Access 2003
    By agarvan in forum Access
    Replies: 4
    Last Post: 08-13-2013, 10:05 AM
  5. Field Level Permissions in MS Access 2003
    By ganeshvenkatram in forum Access
    Replies: 1
    Last Post: 06-21-2011, 06:00 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
  •  
Tech Forums: Microsoft Office Forums