User level security

4 Nov 2005 9:26 AM

Jake

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

--
Jake
Data Manager(Healthcare)

4 Nov 2005 9:41 AM

Keith W

Show quote Hide quote

"Jake" <J***@discussions.microsoft.com> wrote in message
news:52A884D7-3D62-49DC-8E76-E9ECFFEEB24E@microsoft.com...
>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

4 Nov 2005 10:26 AM

Jake

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.

--
Jake
Data Manager(Healthcare)

Show quoteHide quote

"Keith W" wrote:

> "Jake" <J***@discussions.microsoft.com> wrote in message
> news:52A884D7-3D62-49DC-8E76-E9ECFFEEB24E@microsoft.com...
> >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
>
>
>

4 Nov 2005 10:56 AM

Keith W

"Jake" <J***@discussions.microsoft.com> wrote in message
news:14753ABA-6E4F-4A2C-8D7B-DD8C3AE6B91C@microsoft.com...
>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