tables

[Paul \(OMAC HX\)]

Hi All,

I use access as a members area login. When the username and password are
entered correctly the results form displays a link in to the index login
page.

My question is , is it possible to also have the login recorded in another
table with the users details so i can see the usage of the members area.
Or is this a confliction

The user enters there username and password and in a results form underneath
it pulls up the link this can be seen at www.omachx.com - members area.

Any help is greatly appreciated.

Thank you

Paul

 

[John W. Vinson]

Hi All,

I use access as a members area login. When the username and password are
entered correctly the results form displays a link in to the index login
page.

My question is , is it possible to also have the login recorded in another
table with the users details so i can see the usage of the members area.
Or is this a confliction

The user enters there username and password and in a results form underneath
it pulls up the link this can be seen at www.omachx.com - members area.

Just seeing the form doesn't help much. Yes, of course you can have the login
recorded in another table; I would have at least two tables, a table of Users
with the individual user information (I presume you must already have this!)
and a table of Logins, with the username, date and time logged in, and any
other information that you want to record about the individual login. This
table would NOT contain any "user details" - you'ld get those using a query
joining the two tables.

You'll just need to add code to your login procedure to add a new record to
the logins table.

John W. Vinson [MVP]