User level security

[Guest]

I have a an access 97 database split into application and tables, this
presently resides on a server. It serves multiple users.I have tried to
implement the user level security but have not succeeded. I first created a
new workgroup file, saved it in the same folder as the database on the
server. I then joined this workgroup. I created a new administrator account
and disabled the default MS Access Admin.I have successfully created user and
who belong to a new group that i created. These new users work ok on my
machine.
The problem is i can not get these users to log on to the new secured
database.Access does not present them with a log on screen. I have added
this( "C:\Program Files\Microsoft Office97\Office\MSACCESS.EXE" "W:\Bm
Clinical Data\Databases\Secure BMT Database APPLICATIONS.mdb" /wrkgrp "W:\BM
Clinical\Transplant.MDW /user "Sarah"/excl) to the shortcut target for the
new secured database and still does not work.
Can anyone help please

 

[Keith W]

I have a an access 97 database split into application and tables, this
presently resides on a server. It serves multiple users.I have tried to
implement the user level security but have not succeeded. I first created
a
new workgroup file, saved it in the same folder as the database on the
server. I then joined this workgroup. I created a new administrator
account
and disabled the default MS Access Admin.I have successfully created user
and
who belong to a new group that i created. These new users work ok on my
machine.
The problem is i can not get these users to log on to the new secured
database.Access does not present them with a log on screen. I have added
this( "C:\Program Files\Microsoft Office97\Office\MSACCESS.EXE" "W:\Bm
Clinical Data\Databases\Secure BMT Database APPLICATIONS.mdb" /wrkgrp
"W:\BM
Clinical\Transplant.MDW /user "Sarah"/excl) to the shortcut target for the
new secured database and still does not work.
Can anyone help please
--

The permissions are stored in the mdb file. Are you sure your other user
has an exact copy of yours? Also, have you removed permissions to all
object from the "users" group?

Keith.
www.keithwilby.com

 

[Guest]

I believe the other user is using the same work group files(MDW).And the user
group does not have permission to any objects in the database.My
understanding is the permission are stored in the workgroup file.

 

[Keith W]

I believe the other user is using the same work group files(MDW).And the
user
group does not have permission to any objects in the database.My
understanding is the permission are stored in the workgroup file.

Your understanding is incorrect, the permissions are stored in the mdb, the
mdw stores the users and groups data which the mdb interrogates to determine
whether access is permitted or denied. If *your* mdb has had permissions
altered but your user's hasn't then you will get different results.

Regards,
Keith.
www.keithwilby.com