How do I store user login details am not using access security!

[frantik]

Hi

I have managed to get a login working on my database (with the help of a thread I found. - Thanks BillPower for your wonderful instructions)

However I am having problems recording the user id and log in time. I need to store these in order to record who entered the record and at what time.

At the moment - when the user logs in his details are stored temporarily in a local table. How do I get the user id from here and into a userid field against the relevant record number?

Does that make any sense at all?

Can anyone help please?

Thanks

 

[Rick39]

You might create a user logins table with the RecordID, UserID & Access Time with a one (record table)to many (user logins) relationship and set the defaults for UserID to Environ("username&quot and Access Time to Now()

 

[frantik]

Hi rick

I don't think Environ will work beacuse I am not using Access Logins.

I have a table that is created locally when the user logs in containing UserId, password

However I can not seem to pass the value for Userid from this one record table called Tb_Localusers into another table called Tb_status which contains rec_no, userid, date.

Any ideas?

Thanks

 

[Rick39]

Environ("username&quot returns the NT4 or W2K user name (don't need an Access login)- you can test it in the Immediate Window to verify OR
create a dummy table and set one field's default value to =Envrion("username&quotand add some records

 

[BillPower]

Hi Fran, To be honest, I wish you would post your comments in rmcta's
thread , if you read through rmcta's thread thoroughly, you will see that I
took a lot of criticism over my method. Saying publicly what you said in
your e-mail in the thread would certainly help a lot of others who feel the
same as me about having to rely on Access Security.

This weekend I am dedicating my time to member's that have sent me their
DB's. Make a copy of your DB, delete any sensitive records, zip it up and
send it to me. With a little luck in a few days between us we can
demonstrate to everyone at Tek-Tips how easy it is to setup a bespoke
security system that is fast and actually "Secure" and show how easy it is
to set up an "Audit Trail" app as you've asked for.

I'll leave it up to you,

Bill

 

[WalksWithSky]

fran/billpower:

I'd certainly be interested in the results, should you decide to go ahead. I'm always in favour of something that makes it easier to apply, and from what I've done with billpower's code, it seems to be fairly easy to apply and understand, much easier than Access security.

If you have done the work, I would certainly be interested in the results.

Walks With Sky