Solved

How do I secure an Access 2010 database?

Posted on 2011-02-25
14
753 Views
Last Modified: 2012-05-11
The users should be able to view and manipulate data but not change any of it.

I know to hide the tables, but how do I keep them from changing data via the forms?
0
Comment
Question by:fabi2004
14 Comments
 
LVL 75
ID: 34981659
You could create a Desktop shortcut that opens the db in ReadOnly mode.

mx
0
 
LVL 75

Accepted Solution

by:
DatabaseMX (Joe Anderson - Access MVP) earned 500 total points
ID: 34981672



"C:\Program Files\Microsoft Office\Office10\msaccess.exe" "\\abc\workgroup\xyz\SomeDatabase.mdb" /ro

This is the Command line to do that ...

mx
0
 
LVL 1

Expert Comment

by:TerrySolanen
ID: 34981887
To keep users from modifying the data displayed in the forms, you need to modify each field in the form.

In Design view of the form, right click on the field you want to prevent editing of. (You can also select groups of fields and do this, too.)
Choose Properties at the bottom of the menu that appears.
In the Property Sheet, select the Data tab.
For the Locked value, change the "No" to "Yes".

When you try and edit the values in the form now, you shouldn't be able to edit them.
0
 
LVL 75
ID: 34981923
If you want to do it at the Form level (for ALL forms) ... then just set the Form properties as shown in the image:

But if you have more than one Form ... that could be a lot of work.

mx
Capture1.gif
0
 
LVL 1

Author Comment

by:fabi2004
ID: 34982341
It sounds like it would be less work at the form level than at the control/field level.  Or am I missing something?
0
 
LVL 75
ID: 34982400
"Or am I missing something?"
No.  You've got it.

Even less work using the Read Only open option.

mx
0
 
LVL 84
ID: 34982527
You can also toggle this value in Windows File Properties. Find the .accdb file, right-click it and check the ReadOnly box.
0
Enterprise Mobility and BYOD For Dummies

Like “For Dummies” books, you can read this in whatever order you choose and learn about mobility and BYOD; and how to put a competitive mobile infrastructure in place. Developed for SMBs and large enterprises alike, you will find helpful use cases, planning, and implementation.

 
LVL 1

Author Comment

by:fabi2004
ID: 34982608
I'd love to use the Read Only option, but I can't lock down Access for the users, they may need to use it for other things besides this database.  And if I don't, and they use Access to open the file instead of using the shortcut, they'll be able to edit the data right?
0
 
LVL 75
ID: 34982666
The only issue with the Windows Read Only setting is ... it would apply to everyone. With the desktop short approach, you can selectively chose who has RO and normal access to the db.

mx
0
 
LVL 1

Author Comment

by:fabi2004
ID: 34982721
<<<Windows Read Only setting is ... it would apply to everyone>>>
well, I need to be able to go in and update the data :-)
0
 
LVL 75
ID: 34982763
So ... the Shortcut route then.  Because the Form level approach will also apply to everyone - unless you go to a more extreme scenario ... and set properties based on who is logging in.

mx
0
 
LVL 1

Author Comment

by:fabi2004
ID: 34982786
Just to make sure I understand...using the "shortcut method", a user could open the database from within a running copy of Access and bypass the read-only restriction correct?

I'm probably not going to worry about it since the data is not that sensitive, but I want to make sure I understand what I'm doing.

Thanks again.
0
 
LVL 75
ID: 34982832
"a user could open the database from within a running copy of Access and bypass the read-only restriction correct?"
Sure.  Open Access >> File>>Open ... point to your db and open.

All depends on your comfort level.  Worst case, you can set properties based on who 'logs in' to the db ... disable the Shift Bypass Key, create an MDE ... all of that ... to create a somewhat pseudo read only environment.  But ... I doubt you can make it 100% fool proof.

mx
0
 
LVL 1

Author Comment

by:fabi2004
ID: 34982856
Alright, I'll hide what I can and disable the F11, and Shift, etc.  Then use the Shortcut code to make it "read-only".  As long as I keep a spare copy in case someone destroys the data, this security should be plenty enough.

Thanks so much for your help!
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Password on a button in Access 2013 7 34
combine ShipTo and BillTo Address 3 22
Newbie needs help printing from a form. 10 19
Restrict list data depending upon user name 3 20
This article is a continuation or rather an extension from Cascading Combos (http://www.experts-exchange.com/A_5949.html) and builds on examples developed in detail there. It should be understandable alone, but I recommend reading the previous artic…
Most if not all databases provide tools to filter data; even simple mail-merge programs might offer basic filtering capabilities. This is so important that, although Access has many built-in features to help the user in this task, developers often n…
In Microsoft Access, learn how to use Dlookup and other domain aggregate functions and one method of specifying a string value within a string. Specify the first argument, which is the expression to be returned: Specify the second argument, which …
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…

914 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

20 Experts available now in Live!

Get 1:1 Help Now