Go Back   Access World Forums > Microsoft Access Discussion > General

 
Reply
 
Thread Tools Rate Thread Display Modes
Old 07-24-2007, 09:01 AM   #1
Scott0321
Registered User
 
Join Date: Mar 2007
Posts: 4
Thanks: 0
Thanked 0 Times in 0 Posts
Scott0321 is on a distinguished road
Securing a database

I have two questions. All of my experience has been in Access 2003. My work just upgraded to 2007. I am ready to secure a database that I have now converted to a 2007.

1. Is it possible to set the db to open as read only for everyone on staff except for a few people?

2. How do I set security levels where some can view all tables and others can only view specific tables?

For example, I only want 2 people to be able to modify any data. And I don't want anyone to view the accounts receivables, but they need to see other data on the customers.

Thanks in advance.

Scott0321 is offline   Reply With Quote
Old 07-24-2007, 10:27 AM   #2
rhett7660
Still Learning....
 
Join Date: Aug 2005
Location: Good ol USA
Posts: 371
Thanks: 0
Thanked 0 Times in 0 Posts
rhett7660 is an unknown quantity at this point
If you have the back end on the server.. you can set the permissions for the folder on the server to do what you are asking.......


No one should be able to view the tables, but you and your team.
__________________
Just trying to figure this damn thing out called "Access"
rhett7660 is offline   Reply With Quote
Old 07-24-2007, 11:02 AM   #3
Scott0321
Registered User
 
Join Date: Mar 2007
Posts: 4
Thanks: 0
Thanked 0 Times in 0 Posts
Scott0321 is on a distinguished road
thanks

That will solve the first question.

I am told that 2007 no longer has the ability to make security levels. Maybe that is why I can't find them.

Scott0321 is offline   Reply With Quote
Reply

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Linked Tables and User Level Security mikec Modules & VBA 3 01-22-2006 11:37 PM
Inserting images in database to later view in report Xcite Reports 2 12-02-2005 07:58 PM
Transfer text into a database other than current database gthull644 Modules & VBA 2 06-23-2005 12:36 PM
[SOLVED] updating a open access database with .bat files mrdelhiite Tables 4 06-11-2004 06:47 AM
Trouble with securing database stevievee General 2 02-20-2003 09:23 PM




All times are GMT -8. The time now is 05:19 PM.


Microsoft Access Help
General
Tables
Queries
Forms
Reports
Macros
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Sponsored Links

How to advertise

Media Kit


Powered by vBulletin®
Copyright ©2000 - 2018, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World