>Dear All,
>I have a database that I am placing on a server via the package wizard &
>runtime (i'm the only one with Access).
>Before I do this, I need to set up security so that there are 2 types of
>user able to use the database, 1 type that is read only & 1 type to edit &
>input information.
>Please could someone help me with how I go about this.
>Thanks
>
>Samuel

"Tom van Stiphout" wrote:

> On Thu, 20 Nov 2008 03:08:16 -0800, Ickus
> <Ic***@discussions.microsoft.com> wrote:
>
> There are may ways to do that. Here is a simple one:
> At startup time ask Windows who is logged in. See:
> http://www.mvps.org/access/api/api0008.htm
> I'm assuming you store that value in strLogin.
>
> Have a table with Windows logins and AccessLevel.
>
> At startup time read the AccessLevel of the current user and store it
> in a global variable (say g_AccessLevel). E.g.:
> g_AccessLevel = DLookup("AccessLevel", "tblSecurity", "Login='" &
> strLogin & "'")
>
> In the form_open of each form write:
> if g_AccessLevel = "readonly" then Me.AllowEdits = False
>
> -Tom.
> Microsoft Access MVP
>
>
> >Dear All,
> >I have a database that I am placing on a server via the package wizard &
> >runtime (i'm the only one with Access).
> >Before I do this, I need to set up security so that there are 2 types of
> >user able to use the database, 1 type that is read only & 1 type to edit &
> >input information.
> >Please could someone help me with how I go about this.
> >Thanks
> >
> >Samuel
>

"Tom van Stiphout" wrote:

> On Thu, 20 Nov 2008 03:08:16 -0800, Ickus
> <Ic***@discussions.microsoft.com> wrote:
>
> There are may ways to do that. Here is a simple one:
> At startup time ask Windows who is logged in. See:
> http://www.mvps.org/access/api/api0008.htm
> I'm assuming you store that value in strLogin.
>
> Have a table with Windows logins and AccessLevel.
>
> At startup time read the AccessLevel of the current user and store it
> in a global variable (say g_AccessLevel). E.g.:
> g_AccessLevel = DLookup("AccessLevel", "tblSecurity", "Login='" &
> strLogin & "'")
>
> In the form_open of each form write:
> if g_AccessLevel = "readonly" then Me.AllowEdits = False
>
> -Tom.
> Microsoft Access MVP
>
>
> >Dear All,
> >I have a database that I am placing on a server via the package wizard &
> >runtime (i'm the only one with Access).
> >Before I do this, I need to set up security so that there are 2 types of
> >user able to use the database, 1 type that is read only & 1 type to edit &
> >input information.
> >Please could someone help me with how I go about this.
> >Thanks
> >
> >Samuel
>