Capturing user name

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Please help! Can anyone tell me what would be the easiest way to capture
which user entered a record into the database I have created? Currently users
enter data via forms and select their user name from a drop down box. Now, I
realize I don’t want a user to be able to select a name other than their own.
It seems to me that I could probably create some system where the user enters
his/her name once and then that data can be used to automatically fill in the
employee field in the each record. I have a users table that contains user
names and I began creating a logon type form but I don’t know where to go
from there.

Am I going about this all wrong?
 
Sounds like you are reinventing the wheel.

Access has built-in user-level security that will allow them to login to the
database using a userID and password. You can then put their userid on all
their records when they are added. You can do this in the background using
code or simply using the "default" property of your 'timestamp' field.

You can then include the "cyrrentuser()" in your queries, reports, and forms
to only allow them to see/modify their records if you want.

See the following links for more info.

Make sure to read all the instructions several times and make backup copies
of yout database before trying to implement user-level security.



Security FAQ

http://support.microsoft.com/?id=207793



The Security Whitepaper is also worth reading to help you understand.

http://support.microsoft.com/?id=148555



Joan Wild:

www.jmwild.com/AccessSecurity.htm



Lynn Trapp

http://www.ltcomputerdesigns.com/Security.htm







Rick B
 
by the way, this will not require you to use the User table you said you
created. You also won't need a drop-down field for the user to select from,
nor will you need (or want) to build a login form of any kind. That is all
done through the menus and tools already in Access.
 
Back
Top