?
Solved

how to make an access database read only

Posted on 2011-10-28
10
Medium Priority
?
1,161 Views
Last Modified: 2012-05-12
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?
0
Comment
Question by:knfitz
10 Comments
 
LVL 75
ID: 37045961
Open the db in Exclusive mode ...

mx
0
 
LVL 75
ID: 37045992
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
 

Author Comment

by:knfitz
ID: 37046022
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
Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
LVL 75
ID: 37046054


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
 
LVL 23

Accepted Solution

by:
OP_Zaharin earned 2000 total points
ID: 37046151
- at windows explorer, go to the access database. right click and select properties. then click on Read Only checkbox. then click ok.
0
 
LVL 75
ID: 37046196
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
 
LVL 23

Expert Comment

by:OP_Zaharin
ID: 37046299
- 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
 

Expert Comment

by:Larkwood
ID: 37046384
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
 
LVL 75
ID: 37046481
"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
 
LVL 75
ID: 37046511
The answer to this question is ... in A2010 ... it really cannot be done for all practical purposes.

mx
0

Featured Post

Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

Question has a verified solution.

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

We live in a world of interfaces like the one in the title picture. VBA also allows to use interfaces which offers a lot of possibilities. This article describes how to use interfaces in VBA and how to work around their bugs.
Explore the ways to Unlock VBA Project Password Excel 2010 & 2013 documents. Go through the article and perform the steps carefully to remove VBA Excel .xls file.
In this video, Percona Solutions Engineer Barrett Chambers discusses some of the basic syntax differences between MySQL and MongoDB. To learn more check out our webinar on MongoDB administration for MySQL DBA: https://www.percona.com/resources/we…
Despite its rising prevalence in the business world, "the cloud" is still misunderstood. Some companies still believe common misconceptions about lack of security in cloud solutions and many misuses of cloud storage options still occur every day. …

862 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