how to make an access database read only

I want to make an access 2010 database read only so that no one can change the records that are in it. How do I do that?
knfitzAsked:
Who is Participating?
 
OP_ZaharinCommented:
- at windows explorer, go to the access database. right click and select properties. then click on Read Only checkbox. then click ok.
0
 
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database ArchitectCommented:
Open the db in Exclusive mode ...

mx
0
 
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database ArchitectCommented:
Actually I meant Read Only ... using a Command Line Prompt

Open Read Only
"C:\Program Files\Microsoft Office\Office12\msaccess.exe" "\SomeFolder\SomeDatabase.mdb" /ro

You could also put it on a CD Rom.

mx
0
Network Scalability - Handle Complex Environments

Monitor your entire network from a single platform. Free 30 Day Trial Now!

 
knfitzAuthor Commented:
I need to make sure no one else can open it and edit it. How do I do that so that no one else has the ability to make changes?
0
 
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database ArchitectCommented:


If you mean directly open it, ie a user can directly open the db via what ever means, then about the only thing you can do is put it on a CD ROM ... because User Level Security is no longer available as of A2007.

mx
0
 
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database ArchitectCommented:
Of course, any savvy user can simply uncheck that setting ...

And of course, they can copy a db from a CD ROM to a local folder.

I think the bottom line is ... nothing will be 100 % ...

mx
0
 
OP_ZaharinCommented:
- agree with MX.
- here is another approach of making the data readonly by creating a form to display your data and make it read only. therefore user will not have access to your table directly:

http://www.experts-exchange.com/Microsoft/Development/MS_Access/Access_Forms/Q_24901227.html?sfQueryTermInfo=1+10+30+access+onli+read
0
 
LarkwoodCommented:
You can also create macro's to open your tables or queries in read-only mode. Tie those to your switchboard along with any forms. Then hide your tables on open to prevent the curious out of the data.As was mention before depending on the user's knowledge some can get around this. I work in a large company and havn't had anyone stumble thier way into something I didn;t want them to see.
0
 
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database ArchitectCommented:
"therefore user will not have access to your table directly:"

The *bottom line* here is ... IF ... the user can get to the MDB - and there is really no way to prevent that generally, then they can get in.  Using a form or making the db read only in Explorer is really not going to do much of anything.

mx
0
 
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database ArchitectCommented:
The answer to this question is ... in A2010 ... it really cannot be done for all practical purposes.

mx
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.