Simple list of users

[atledreier]

I am a novice access user, and I'm trying to make something simple.

I am trying to make a absence list for my employees.

I have a list of employees and a list of absence codes.
Each emplyee have a unique number, and the actual list is no problem.

The problem is that I want each employee to 'log on' to the database
with their emplyee number and only be able to edit and access their
own data.

I have a list of around 1200 emplyees in Excel right now.

Any tips on how I can do this without too much fuzz? No need for this
to be bulletproof, just a simple thing to limit access for all but the
supervisors.

 

[Tom van Stiphout]

On Wed, 7 Apr 2010 05:36:11 -0700 (PDT), atledreier

One simple way is to ask Windows who is logged in to the computer:
www.mvps.org/access/api/api0008.htm
Then compare the result with a list of supervisor login names. You
could have them in a table and use DLookup to find out if the current
user is in the list.
If the answer is no, you can use DoCmd.Quit to close the application
for this unapproved user.

-Tom.
Microsoft Access MVP

 

[Roger Carlson]

On my website (www.rogersaccesslibrary.com), is a small Access database
sample called "UserSeesOnlyHisRecords.mdb" which illustrates how to do this.
You can download it for free here:
http://www.rogersaccesslibrary.com/forum/topic220.html

--
--Roger Carlson
MS Access MVP
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/wa.exe?SUBED1=ACCESS-L