Re: Capture Pswrd & Userid To Auto Populate Form

"Nikki Norris" wrote in message:
news:61d31ea00a0a4ff382ec0e3179f514c3@xxxxxxxxxxxxxxxxxxxx

> Hello,
> I have a table of user id, password & name. I have a form that in order to
> modify it you must have a password. This is captured in my password
> routine.
>
> 1. I need to capture the userid and name at the password sign-in level.
> 2. Once I have the username, I need to auto populate the form with the user
> name, date and timestamp.
>
> Does anyone have a routine or code for this?

Hi Nikki,

Yes, I have done something like this before and can certainly share some code
with you, however, I must point out that this type of "home-grown" security
is by no means *secure* at all. Anyone with a little bit of Access knowledge
can bypass this stuff pretty easily.

How Access-savvy are your users and what type of data are you trying to protect?
Have you considered implementing built-in Access User Level Security (ULS)?
It is much more secure than creating something yourself and you have a lot
more control over individual database objects.

--
Jeff Conrad
Access Junkie
Bend, Oregon


.

Relevant Pages

  • Re: Securing BackEnd DB file
    ... I should enable the user level security before I split into two files (front ... I want to secure the backend also with the same ... > workgroup should not be altered). ...
    (microsoft.public.access.security)
  • Re: RATECRYPT() Version 1.2 included below
    ... Mel Smith wrote: ... The method uses no roundfunction and like the xor function requires no separate encrypt/decrypte routine. ... It is as secure as the rand1function which isn't all that secure but certainly should suffice to obscure the rate. ... function ft_rand1(nRate, nEmpNo) ...
    (comp.lang.clipper)
  • Re: General security questions
    ... particularly secure but the client wants to be able to track which of the 3 ... the easiest thing to do would be to capture theie Windows/login name and use ... User Level Security is an advanced topic, ...
    (microsoft.public.access.security)
  • Re: Looking for Advice Regarding Access2000 Security
    ... > I'm looking for some advice as to which is more secure in Access 2000: ... Don't count on it to protect anything ... delivered as MDE with User Level Security ... corporate application -- I don't know what they spent before I was involved ...
    (microsoft.public.access.gettingstarted)
  • Re: 2003 or 2007 Security
    ... User level security isn't secure enough for ssns. ... Free tools on the internet ... Access 2007 supports user level security for all mdbs, ... No amount of user built security will keep the data secure in a file based db. ...
    (microsoft.public.access.security)