• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 764
  • Last Modified:

How do I secure an Access 2010 database?

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
fabi2004
Asked:
fabi2004
1 Solution
 
DatabaseMX (Joe Anderson - Microsoft MVP, Access and Data Platform)Commented:
You could create a Desktop shortcut that opens the db in ReadOnly mode.

mx
0
 
DatabaseMX (Joe Anderson - Microsoft MVP, Access and Data Platform)Commented:



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

This is the Command line to do that ...

mx
0
 
TerrySolanenCommented:
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
VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

 
DatabaseMX (Joe Anderson - Microsoft MVP, Access and Data Platform)Commented:
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
 
fabi2004Author Commented:
It sounds like it would be less work at the form level than at the control/field level.  Or am I missing something?
0
 
DatabaseMX (Joe Anderson - Microsoft MVP, Access and Data Platform)Commented:
"Or am I missing something?"
No.  You've got it.

Even less work using the Read Only open option.

mx
0
 
Scott McDaniel (Microsoft Access MVP - EE MVE )Infotrakker SoftwareCommented:
You can also toggle this value in Windows File Properties. Find the .accdb file, right-click it and check the ReadOnly box.
0
 
fabi2004Author Commented:
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
 
DatabaseMX (Joe Anderson - Microsoft MVP, Access and Data Platform)Commented:
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
 
fabi2004Author Commented:
<<<Windows Read Only setting is ... it would apply to everyone>>>
well, I need to be able to go in and update the data :-)
0
 
DatabaseMX (Joe Anderson - Microsoft MVP, Access and Data Platform)Commented:
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
 
fabi2004Author Commented:
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
 
DatabaseMX (Joe Anderson - Microsoft MVP, Access and Data Platform)Commented:
"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
 
fabi2004Author Commented:
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

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now