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.

• Ms Access 2010 Trial

Ms Access 2010 Trial

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.

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. 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: 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.

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: 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.

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.

Generally, a download manager enables downloading of large files or multiples files in one session. Many web browsers, such as Internet Explorer 9, include a download manager. Stand-alone download managers also are available, including the Microsoft Download Manager. If you do not have a download manager installed, and still want to download the file(s) you've chosen, please note:. You may not be able to download multiple files at the same time. In this case, you will have to download the files individually.

(You would have the opportunity to download individual files on the 'Thank you for downloading' page after completing your download.). Files larger than 1 GB may take much longer to download and might not download correctly.

You might not be able to pause the active downloads or resume downloads that have failed. The Microsoft Download Manager solves these potential problems.

It gives you the ability to download multiple files at one time and download large files quickly and reliably. It also allows you to suspend active downloads and resume downloads that have failed. Microsoft Download Manager is free and available for download now.