User Accounts in Access 2007

[Ickus]

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]

On Thu, 20 Nov 2008 03:08:16 -0800, Ickus

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

 

[Ickus]

Tom,

I'm a bit of a novice with the programming,

Please can you explain the following:

I'm assuming you store that value in strLogin.

store it

in a global variable (say g_AccessLevel) - Where do I store & how?

This is probably childs play for most people, but I'm just getting confused.

Please help once again

Thanks

 

[Ickus]

Tom,

Please could you run through this stage by stage, some of the language you
have used in unfamiliar to me.

Thanks

Samuelo