Setting security in Access 97

[Rob]

I have set up group security rights in an Access 97
database (Admins and Users). On my workstation, all
security settings work, using the Access security user
logon prompt at open.

However, security is not enabled on the other workstations
throughout my office. Therefore, other users within the
office can access the database as admins, that being the
default for a terminal without an admin password
assigned. How can I force users to logon as
either "Admin" or "User" and apply the respective security
settings whenever this database is opened, without
individually activating security on each terminal? I want
to avoid having to replicate the security settings through
a VBA interface. Thanks in advance for any assistance.

-Rob

 

[Jack MacDonald]

If you can open the file from other workstations, then you have missed
a step in securing the file. The definitive source for security is the
Microsoft Security FAQ, but I have also written a step-by-step for
properly securing a database. Links to both are on the website in my
signature.

I have set up group security rights in an Access 97
database (Admins and Users). On my workstation, all
security settings work, using the Access security user
logon prompt at open.

However, security is not enabled on the other workstations
throughout my office. Therefore, other users within the
office can access the database as admins, that being the
default for a terminal without an admin password
assigned. How can I force users to logon as
either "Admin" or "User" and apply the respective security
settings whenever this database is opened, without
individually activating security on each terminal? I want
to avoid having to replicate the security settings through
a VBA interface. Thanks in advance for any assistance.

-Rob

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