[mso] Re: Make Access DB Read Only
- From: "Linda F. Johnson" <linda@xxxxxxxxxxxxxxxxxxxxxxxxxxx>
- To: <mso@xxxxxxxxxxxxx>
- Date: Tue, 12 Dec 2006 18:32:32 -0500
If I'm understanding what you want to do, Ray, I'm thinking you need to look
into "permissions" .... If you go to the Tools menu and choose Security,
you'll see you can create groups, then assign different users to different
groups ... Then you can set each group to have different permissions ... So,
that way different people can edit different parts of the database.
It also sounds like you need to do some research on front end and back end
databases ... Basically, it means your queries, forms, etc. all live in the
front end database which the users have full access to, but then the tables
live in a separate back end database, which only administrators have rights
to. To do this, go to the Tools menu and choose Database Utilities>
Database Splitter.
There are more ways to do what you want, I'm sure, but these two come to
mind as options for you.
Good luck.
Linda F. Johnson
Linda's Computer Stop
Author, MOS: Excel 2003 Study Guide, published by John Wiley and Sons
http://personal-computer-tutor.com
-----Original Message-----
From: mso-bounce@xxxxxxxxxxxxx [mailto:mso-bounce@xxxxxxxxxxxxx] On Behalf
Of Ray Shapp
Sent: Tuesday, December 12, 2006 12:48 PM
To: mso@xxxxxxxxxxxxx
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
*************************************************************
Other related posts:
