Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations biv343 on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

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

Status
Not open for further replies.

frantik

Technical User
Nov 9, 2002
93
GB
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
 
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") and Access Time to Now()
 
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
 
Environ("username") 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")and add some records
 
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
 
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
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top