[mso] Re: Make Access DB Read Only

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).
http://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: