user level security

  • Thread starter Thread starter denise
  • Start date Start date
D

denise

Hi, I've tried following the directions for setting up
user level security on our access database. But though I
am prompted to enter a password, other users are not. The
database is on a server and I only have the one MDW file
there. Could users have something on their pc's that is
overriding it? Will I need to go to each pc and check?
This is difficult to understand, but I thought I had it
right. I appreciate any help. Thanks!
 
Hi Denise,

I'm not sure exactly what steps and how much of the directions you have
followed. It doesnt sound complete to me. By default, each copy of Access
will open a database using system.mdw located at the workstation. Access
will also open a database using the user "Admin".

So if other users can open the database, the database has not been properly
secured.

Does the user "Admin" still exist in the MDW file on the server? Does it
still have administrative rights?


Immanuel Sibero
 
-----Original Message-----
Hi, I've tried following the directions for setting up
user level security on our access database. But though I
am prompted to enter a password, other users are not. The
database is on a server and I only have the one MDW file
there. Could users have something on their pc's that is
overriding it? Will I need to go to each pc and check?
This is difficult to understand, but I thought I had it
right. I appreciate any help. Thanks!
.
There is a file called system.mdw on my c drive. There is
Click to expand...
also a file called Secured1.mdw on the server. They're
not exactly the same. the one on the server is the one I
set up, and user Admin does have administrative rights. If
the file on the workstation pc is the one that counts, how
can I get the one on the server to overrise it? Thanks a
lot for your help!
 
Hi Lynn,

By default all workstation running Access uses system.mdw on the local drive
and logs in to any database as "Admin".
You can change this by:

- creating a shortcut on the desktop of the workstation like so:
"<path to msaccess.exe>" "<path to frontend.mdb>" /wrkgrp "<path to
security.mdw>"
- joining the workstations (i.e. Workgroup Administration) to your preferred
Secured1.mdw. This method is not commonly used.

Another issue I see is that Admin is set up as a user with administrative
rights in your Secured1.mdw. This means any copy of Access can open the
database, since any copy of Access uses the default system.mdw and logs in
as Admin.

Can you tell me where the source of your directions in setting up user level
security? There should be a part discussing the importance of either
deleting the user Admin or stripping the user Admin of administrative rights
in your Secured1.mdw.



Immanuel Sibero
 
See my paper in the website in my signature. It might help you to
understand the steps required to secure the database.

Hi, I've tried following the directions for setting up
user level security on our access database. But though I
am prompted to enter a password, other users are not. The
database is on a server and I only have the one MDW file
there. Could users have something on their pc's that is
overriding it? Will I need to go to each pc and check?
This is difficult to understand, but I thought I had it
right. I appreciate any help. Thanks!
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
 
Thanks to Jack MAcDonald!
This was just what I was looking for - thorough explanations and a complete picture of how things are connected. After searching the Help files / sites in all different ways without getting good enough answers - I finally got it !
Thanks!!
 
Back
Top