Log in before using Access

[khashid via AccessMonster.com]

Hi, I am not sure if this is possible but i have a feeling it can be done in
access.

I have a table with Agent Codes such as for David "DA" then i have a form
where every agent does a transaction,

What exactly I want is that every Agent logs in to database using their
specif ID and password. So whenever they do any changes edit/add their Agent
Code would updates by it self. And also noone would be able to change it and
nor anyone could do any changes without using their ID and Password.

If its possible any help would be appreciated.

 

[Rick B]

Yes. You would have to implement the built-in User Level Security.

I'd suggest you make a backup of your database, then read the following
items. Please read them completely before you start following the steps.
It is important that you follow all the steps in order. If you don't, you
could lock yourself out of the database, or you could leave holes in your
security.

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