Security for 2 files

  • Thread starter Thread starter Jeff
  • Start date Start date
J

Jeff

I have 2 different databases, one in which very few people
have write access and the other on I need everyone to have
write access. Is there a way to have access look at 2
different wrkgrp files? When opening one, there should be
no restrictions, and the the other needs to stay secure.
 
Same workgroup, different access rights for each person in each
database. You can even have different access right to each table, form,
macro, report or query for each person in each database all using the same
workgroup.

I suggest you start by reading
http://support.microsoft.com/default.aspx?scid=kb;[LN];207793

Access security is a great feature, but it is, by nature a complex product
with a very steep learning curve. Properly used it offers very safe
versatile protection and control. However a simple mistake can lock
everyone including God out.

Practice on some copies to make sure you know what you are doing.
 
In the "open" database, give the Admin user full permissions to all
objects. In the "closed" database, deny all permissions to the Admin
user, but provide the required permissions to a specified group.
Finally put the people into the "priviledged" group that need the
special permissions.
See my signature for addtional details.

I have 2 different databases, one in which very few people
have write access and the other on I need everyone to have
write access. Is there a way to have access look at 2
different wrkgrp files? When opening one, there should be
no restrictions, and the the other needs to stay secure.
Click to expand...


=======================================================
Jack MacDonald
remove UPPERCASE LETTERS from email address
Vancouver, B.C. Canada
Info about MSAccess user-level security
www.geocities.com/jacksonmacd
 
Back
Top