Re: Finding Records

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

"Mal" <Mal@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:27323B5B-B601-4DF4-BFC4-924A753D47A5@xxxxxxxxxxxxx
> I have created a simple login screen for security and I am trying to
> figure out how to create a way that only the records show from the
> login point forward that this user created. I don't want other people
> seeing those records unless it is a adminisitrator.
> I am not that advanced a user so simple is good.
>
> Thank You for your help
> Mallory

You need to set it up so that all records added are stamped
automatically with the current user. That means there must be a field
in the table to store the UserID, and the form whereby records are added
must set that field for each record added. If you're managing your own
security, rather than using Access's built-in user-level security (which
admittedly is rather finicky to set up, if you want your database to be
secure) then you need to have a global variable or function that will
return the user's login ID whenever it's called for. Then you can
either set the DefaultValue of a hidden control on the form to the
function that returns the UserID, or else use an event procedure in the
form's BeforeUpdate event to assign the UserID to the field before the
record is written out.

You also need to base all forms and queries of this data on a query that
returns only those records that match the current UserID, UNLESS that
UserID is an administrator. Naturally, you also need some means to
determine whether the user is an administrator or not, which is
something you can do at logon time.

--
Dirk Goldgar, MS Access MVP
www.datagnostics.com

(please reply to the newsgroup)


.

Relevant Pages

  • Re: Help Me to prevent crack my admin Password
    ... Obviously you would be able to tell as the Administrator account password is ... and logoff events in the security event log. ... Please note I cannot respond to e-mailed questions. ... > fellows is loging in as my administrator login and he is ...
    (microsoft.public.windowsxp.security_admin)
  • Re: Finding Records
    ... ID with the login person and what data entry that has been done. ... > in the table to store the UserID, and the form whereby records are added ... > security, rather than using Access's built-in user-level security (which ... > determine whether the user is an administrator or not, ...
    (microsoft.public.access.formscoding)
  • Re: Help Me to prevent crack my admin Password
    ... > If you encrypt the ENTIRE harddisk then the common tools that can reset ... > Administrator account password will not be able to read or write to the ... > security compromising tools. ... >> fellows is loging in as my administrator login and he is ...
    (microsoft.public.windowsxp.security_admin)
  • Membership of user in Active Directory
    ... active directory related and security related. ... Also, if I login as Administrator locally, I am able to do ... doesn't it defeats the purpose of security whereby ...
    (microsoft.public.win2000.active_directory)
  • Re: Finding Records
    ... >>> I have created a simple login screen for security and I am trying to ... >> UserID, or else use an event procedure in the form's BeforeUpdate ... >> UNLESS that UserID is an administrator. ...
    (microsoft.public.access.formscoding)