[mso] Re: Make Access DB Read Only
- From: Cathy.Evans@xxxxxxxxx
- To: mso@xxxxxxxxxxxxx
- Date: Tue, 12 Dec 2006 23:37:14 -0500
My first thought would be to convert to front end/back end and make the
font end an .mde so they can't get to any code or form/report designs to
make changes there, and make the forms/reports read only. You mentioned
the database has predefined queries. You can create a datasheet read only
form out of those queries that should give similar results.
There is a very interesting thread here that covers some interesting
aspects to consider.
http://www.utteraccess.com/forums/showflat.php?Cat=&Board=81&Number=1303389&Zf=&Zw=protect%20tables&Zg=0&Zl=a&Main=1277531&Search=true&where=&Zu=&Zd=g&Zn=&Zt=e&Zs=a&Zy=#Post1303389&Zp=
Hope this helps, Cathy
Ray Shapp
<ras45@xxxxxxxxxxxxx>
Sent by:
To
mso-bounce@freelists. mso@xxxxxxxxxxxxx
org
cc
12/12/2006 12:47 PM
Please respond to mso
Subject
[mso] Make Access DB Read
Only
Hello All,
How to make an Access database read only?
A friend has installed a desktop computer in a public area for club members
to
consult. He wants to allow anyone to run any of the predefined queries and
view any of the reports he has designed, but he doesn't want anyone to
change
any of the data or delete any or all of the DB.
The PC is not networked and it is not connected to the internet.
He is using Office 2003 on a WinXP Home SP2 box.
He tried placing the DB in a password-protected non-administrator account,
but
anyone who has the password of the account can still modify the data or
delete
the DB.
Any ideas?
Ray Shapp
*************************************************************
You are receiving this mail because you subscribed to mso@xxxxxxxxxxxxx or
MicrosoftOffice@xxxxxxxxxxxxxxxx
To send mail to the group, simply address it to mso@xxxxxxxxxxxxx
To Unsubscribe from this group, visit the group's homepage and use the
dropdown menu at the top. This will allow you to unsubscribe your email
address or change your email settings to digest or vacation (no mail).
//www.freelists.org/webpage/mso
If you are using Outlook and you see a lot of unnecessary code in your
email messages, read these instructions that explain why and how to fix it:
http://personal-computer-tutor.com/abc3/v28/greg28.htm
*************************************************************
-----------------------------------------------------------------------------------------------------
The information transmitted is intended only for the person
or entity to which it is addressed and may contain proprietary,
business-confidential and/or privileged material.
If you are not the intended recipient of this message you
are hereby notified that any use, review, retransmission,
dissemination, distribution, reproduction or any action taken
in reliance upon this message is prohibited. If you received
this in error, please contact the sender and delete the
material from any computer. Any views expressed in this message
are those of the individual sender and may not necessarily reflect
the views of the company.
-------------------------------------------------------------------------------------------------------
*************************************************************
You are receiving this mail because you subscribed to mso@xxxxxxxxxxxxx or
MicrosoftOffice@xxxxxxxxxxxxxxxx
To send mail to the group, simply address it to mso@xxxxxxxxxxxxx
To Unsubscribe from this group, visit the group's homepage and use the dropdown
menu at the top. This will allow you to unsubscribe your email address or
change your email settings to digest or vacation (no mail).
//www.freelists.org/webpage/mso
If you are using Outlook and you see a lot of unnecessary code in your email
messages, read these instructions that explain why and how to fix it:
http://personal-computer-tutor.com/abc3/v28/greg28.htm
*************************************************************
Other related posts:
