none
Access 2010 User Security Question

    Question

  • I have to implement a "simple" admin/user security for an Access database that we recently created in Access 2010.

    Before I go further, please note that this database will be running on a simple 3-computer peer-to-peer workgroup with no access to SharePoint or a SQL Server. Data is stored on a NAS.

    • The database is a simple db for a non-profit group that contains information about donors and their annual dues.
    • There are 5 people that will have access to the database.
    • One person needs the ability to have full control over the data. (i.e. Add/Delete/Change).
    • The other 4 people need to be restricted to only have rights to VIEW the data.

    This is the first database that I have worked with using Access 2010. Previously, I was using 2003, where I was able to implement "user level security". I have done enough searching to discover that with 2010, (and 2007), this is gone.

    I would be happy with the simple ability to have an EDIT button on the Form that is enabled for the "admin" user and disabled for everyone else.

    Does anyone have any SIMPLE solutions?

    NOTE: I am not a "code-jockey". I am very comfortable with forms/tables/queries/reports, but have not needed to work with modules or VBA.,

    Therefore, most "solutions" I have read online are way over my head. So please, something that I can understand and implement...

    I appreciate ANY help on this... Thank you in advance for all replies.


    Brian Beckers Technology Consultant Fireside Office Solutions Bismarck, North Dakota

    Monday, April 09, 2012 2:00 PM

Answers

  • Hi Brian,
    We can set the database opening in read-only mode to make the users can only view the data.
    Following the steps:
    First, verify the location of the Msaccess.exe file on your computer. If you accepted the default folder locations when you installed Access, the Msaccess.exe file is typically located at:
    C:\Program Files (x86)\Microsoft Office\Office14\MSACCESS.EXE
    If you do not find the Msaccess.exe file at that location, search for the file and make a note of the full path.
    1. Right-click the Windows desktop, point to New, and then click Shortcut on the shortcut menu.
    2. On the first page of the Create Shortcut Wizard, in the Type the location of the item box, type a quotation mark ("), enter the full path for the Msaccess.exe file (including the file name), and then type a quotation mark. (Alternatively, click Browse to locate and select the file. In this case, the quotation marks are added automatically.)
    3. Following the closing quotation mark, type a space, and then type the switch and any parameters. If the parameter is a file path that includes spaces, it also must be enclosed in quotation marks. For example:
    "c:\program files\microsoft office\office12\msaccess.exe" /ro "c:\My Folder\My Database.accdb"
    4. Click Next.
    5. In the Type a name for this shortcut box, type a name for the shortcut, and then click Finish.
    The wizard creates the shortcut and places it on the desktop.
    6. Whenever you want to start Access in this particular customized way, double-click the shortcut.
    For information, please refer to the link:
    http://office.microsoft.com/en-us/access-help/command-line-switches-for-access-HA010166605.aspx?CTT=5&origin=HA010342116
    The link is for Access 2007, but the steps are the same for Access 2010. In addition, the full path of Msaccess.exe is different.

    Jaynet Zhang

    TechNet Community Support

    Wednesday, April 11, 2012 1:08 AM
  • Hi Brian,

    You might take a look at ScotGem's login security setup, which is not that complicated to implement.

    There is an example database and a step by step documentation. You might give that a try.

    http://scottgem.wordpress.com/2010/01/12/creating-login-security-using-access-vba/

    Hope this helps,


    Daniel van den Berg | Washington, USA | "Anticipate the difficult by managing the easy"

    Please vote an answer helpful if they helped. Please mark an answer(s) as an answer when your question is being answered.

    Tuesday, April 10, 2012 12:54 AM

All replies

  • Hi Brian,

    You might take a look at ScotGem's login security setup, which is not that complicated to implement.

    There is an example database and a step by step documentation. You might give that a try.

    http://scottgem.wordpress.com/2010/01/12/creating-login-security-using-access-vba/

    Hope this helps,


    Daniel van den Berg | Washington, USA | "Anticipate the difficult by managing the easy"

    Please vote an answer helpful if they helped. Please mark an answer(s) as an answer when your question is being answered.

    Tuesday, April 10, 2012 12:54 AM
  • Hi Brian,
    We can set the database opening in read-only mode to make the users can only view the data.
    Following the steps:
    First, verify the location of the Msaccess.exe file on your computer. If you accepted the default folder locations when you installed Access, the Msaccess.exe file is typically located at:
    C:\Program Files (x86)\Microsoft Office\Office14\MSACCESS.EXE
    If you do not find the Msaccess.exe file at that location, search for the file and make a note of the full path.
    1. Right-click the Windows desktop, point to New, and then click Shortcut on the shortcut menu.
    2. On the first page of the Create Shortcut Wizard, in the Type the location of the item box, type a quotation mark ("), enter the full path for the Msaccess.exe file (including the file name), and then type a quotation mark. (Alternatively, click Browse to locate and select the file. In this case, the quotation marks are added automatically.)
    3. Following the closing quotation mark, type a space, and then type the switch and any parameters. If the parameter is a file path that includes spaces, it also must be enclosed in quotation marks. For example:
    "c:\program files\microsoft office\office12\msaccess.exe" /ro "c:\My Folder\My Database.accdb"
    4. Click Next.
    5. In the Type a name for this shortcut box, type a name for the shortcut, and then click Finish.
    The wizard creates the shortcut and places it on the desktop.
    6. Whenever you want to start Access in this particular customized way, double-click the shortcut.
    For information, please refer to the link:
    http://office.microsoft.com/en-us/access-help/command-line-switches-for-access-HA010166605.aspx?CTT=5&origin=HA010342116
    The link is for Access 2007, but the steps are the same for Access 2010. In addition, the full path of Msaccess.exe is different.

    Jaynet Zhang

    TechNet Community Support

    Wednesday, April 11, 2012 1:08 AM
  • Hi Jaynet,

    It's nice that you marked your own answer as the only answer, but I believe that my answer is certainly an approach the OP can try to have an easy solution for login security, which isn't that complicated to implement.

    With that said, there are more ways that can lead to Rome ...

    Best regards,


    Daniel van den Berg | Washington, USA | "Anticipate the difficult by managing the easy"

    Please vote an answer helpful if they helped. Please mark an answer(s) as an answer when your question is being answered.


    • Edited by danishani Monday, April 16, 2012 2:10 AM typo
    Monday, April 16, 2012 2:10 AM
  • Thank you Jaynet, this solution worked great for what I needed to accomplish.


    Brian Beckers Technology Consultant Fireside Office Solutions Bismarck, North Dakota

    Monday, April 16, 2012 9:57 PM
  • Daniel,

    Thank you for the reply. While this solution looks to be workable, it is much more than what I wanted to do.

    I already setup the solution proposed by Jaynet before I read your reply, and it is working great.

    Thank you again for your help!


    Brian Beckers Technology Consultant Fireside Office Solutions Bismarck, North Dakota

    Monday, April 16, 2012 9:59 PM