[mso] Re: Make Access DB Read Only

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).
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
*************************************************************




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