Creating users

N

Newbie

I'm fairly new to Access, but I'm trying to set up an order entry database
and need to be able to create unique user logons. In addition, I need to
create a field that automatically populates the user ID for each record
entered by that user. Please help. Thanks.
 
K

Klatuu

You can set up Access User Level security, but before you do, you will want
to do some extensive research and study on it. It is complex and tricky. It
is not uncommon for someone to accidently lock the security so tight that no
one can get into an database, so be careful.

As to updating a field in your table each time a user adds a record, you
just need to bind the field to a control on your form. It can be hidden.
The make the default value of the field:
=CurrentUser()

That will put the value of the currently logged in user in the field. If
user level security is not set up, it will return Admin for all users.
 
J

John W. Vinson

Access 2003
Windows XP Professional
Click to expand...

Let me just chime in and emphasize that Dave is correct: Access security is
pretty tricky.

Download the Microsoft Access 2000 Security FAQ:

http://support.microsoft.com/kb/207793/en-us

Don't worry, it applies through 2003. Note that workgroup security has been
*removed* from 2007, and you cannot apply it to a 2007 format .accdb database;
bear that in mind if you plan to upgrade.

Print out the FAQ. Read it, carefully.

Get a good night's sleep.

Read the FAQ again, even MORE carefully.

Make a backup of your database; verify that it works and put it in a safe
place.

Secure your database using the printout as a guide. I'd suggest checking off
each step as you do.

Workgroup security can be broken, but done correctly it will probably meet
your needs. If the contents of the data are really business-critical and/or if
you're worried about serious hackers deliberately trying to get at data they
shouldn't have, then you should really consider putting the data in a properly
secured SQL Server (and using Access as a frontend).
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Unique ID/Duplicate Entry 3
Defaulting data from one table to another 1
Turning a 3 column flat file into a "3D" Table 2
Access Automatically Send a notification email once a record is added 0
How to calculate the age in a particular month? 0
Create New Entry From Exisiting Data 8
Creating a table and relationship for counseling notes question 2
Dynamic # of fields 6

Top