User Login and Tracking

[oakbarn]

I know vba with MSAccess but need to create a web app of an MS Access App.

I need to make it multi user with the user only being able to see and edit his own data. The db is quite simple and could have only a single table, but could divide into one main table with a couple of relational tables.

I need the user to be able to login in and create his own password. I would want the user to have to validate (e-mail) simular to registering for this forum.

I noticed that this forum is PHP driven. I thought that might be a better solution but a higher learning curve from vba to vb.net

I posted this on the database forum but got no response.

[wengang]

sounds easy enough.
Though I would do it in ASP, not PHP.
Are you stuck on some point?

[oakbarn]

Just wondering if there is a snippet out there that is available. This would seem like a common occurance.

[wengang]

well a snippet would be small, right?
what exactly would the snippet do? a register page?

[oakbarn]

Basically I want a login page that a new user could also register on and retrieve a lost password to the registered e-mail. Also would use the login id to filter the dataset.

[wengang]

ok. but before you do start, do you have an automatic emailer like CDO,CDONTS, JMAIL, ASPEMAIL or other?

You will need that if the website is going to email forgotten passwords to the user, or if you want to test their email address by sending the login activation to the email address.

The rest is easy.

Set up a database with tblUsers
userid
username
password
status
authorization
email
whatever else

then build a form in ASP with matching input text fields.

When the form is submitted, add the data from the form to the data table.

Then the user will immediately be able to log in with the information (after you do a login page). Two basic ways are to make a login page or include login on a full page, or to make a pop-up box and a link on the main page. user clicks link, gets popup window and logs in.

OK, I found an old one that I wrote several years ago. Nothing special, just a basic login page. This one is written to be included on a larger page.
Take a look at that and see if you have any questions.

[oakbarn]

Thanks, I will look at your code. I do not know what my server has for e-mail but I can move to a different server if needed. I know how to do this for MS Access and have written in that since version 1.0 came out in the early 90's. Have finanially found a need to go web based.