Solved

make access db readonly?

Posted on 2015-01-04
5
141 Views
Last Modified: 2015-01-11
is it possible to make an MSAccess DB (2002) readonly? a command or setting to not allow writes, but reports ok.
0
Comment
Question by:25112
5 Comments
 
LVL 61

Assisted Solution

by:mbizup
mbizup earned 167 total points
ID: 40530470
Try setting the file properties/permissions of the .mdb file to "Read Only" (through Windows, not Access).

Alternatively, you can set the Allow Additions/Edits/Deletions properties of your data entry forms to "NO".
0
 
LVL 5

Author Comment

by:25112
ID: 40530542
>>properties/permissions of the .mdb file to "Read Only"
one step solution...

>>Allow Additions/Edits/Deletions properties of your data entry forms to "NO".
this may be the better solution as in the other case, somebody maybe able to go and uncheck the RO.
this can be exacting as there are 100s of form.. is it possible to do through query in one shot.
0
 
LVL 45

Assisted Solution

by:aikimark
aikimark earned 166 total points
ID: 40530555
potentially, you could iterate the queries, forms (maybe tables) to make them read only.  Of course, it is possible for a user to undo these settings, just as you envision for the file/folder settings.
0
 
LVL 74

Accepted Solution

by:
Jeffrey Coachman earned 167 total points
ID: 40531974
It all depends on what your ultimate goal is, ...
To make the DB read only, ...or t have a system that just does Reporting...

Will this "ReadOnly" database be associated (Linked) with a Non-readonly (editable) version of the database?

Are you concerned about a user maliciously changing the data, ...or are you just trying to just give users an interface just for reporting, ...so they don't "accidentally" change the data..?

If you set the ReadOnly property of the database File, ...then you will have to remember to do this every time you publish a newer version of the your reporting database (for example, you update the database to include/exclude reports(s)).

If the goal is to simply give the user a direct way to view reports only, then you can create a form interface in which the user is simply presented with the various reports.
You can set the Hidden attribute of all the other objects, then hide the database window when the db opens. (among other things)
But again, ...this would require a separate "Reporting" version of the database...

...Attached is one example of a Database specifically designed to run reports.

Again, this all depends of your "exact" needs, ...
So it would be helpful if you stated exactly what you do, and do not, want users to do in this database,..and also state if you will be doing this for two separate (but linked) database files

JeffCoachman
Reporting.mdb
0
 
LVL 5

Author Comment

by:25112
ID: 40543591
helped.

thanks for the example, Jeff.
0

Featured Post

Complete VMware vSphere® ESX(i) & Hyper-V Backup

Capture your entire system, including the host, with patented disk imaging integrated with VMware VADP / Microsoft VSS and RCT. RTOs is as low as 15 seconds with Acronis Active Restore™. You can enjoy unlimited P2V/V2V migrations from any source (even from a different hypervisor)

Question has a verified solution.

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

Entity Framework is a powerful tool to help you interact with the DataBase but still doesn't help much when we have a Stored Procedure that returns more than one resultset. The solution takes some of out-of-the-box thinking; read on!
I annotated my article on ransomware somewhat extensively, but I keep adding new references and wanted to put a link to the reference library.  Despite all the reference tools I have on hand, it was not easy to find a way to do this easily. I finall…
Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…
What’s inside an Access Desktop Database. Will look at the basic interface, Navigation Pane (Database Container), Tables, Queries, Forms, Report, Macro’s, and VBA code.

778 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