User Accounts in Access 2007

  • Thread starter Thread starter Ickus
  • Start date Start date
I

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
 
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
 
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
 
Tom,

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

Thanks

Samuelo
 
Back
Top