database admin - many users?

[startbar]

hi, im looking for some code so that i can create a form that users can sign up with and create an entry into an access database but so they can edit it aswell, but obviously only their entry - is this possible?

thanks

[Spudhead]

Yes, I believe there are some excellent tutorials on the matter at www.4guysfromrolla.com and www.w3schools.com

[angst]

http://www.aspfaqs.com/aspfaqs/ShowCategory.asp?CatID=8

and

http://www.aspfaqs.com/aspfaqs/ShowCategory.asp?CatID=12

thoes two will help you.

[Bullschmidt]

And/or you may want to search here:

HotScripts.com
http://www.hotscripts.com

Planet Source Code
http://www.planet-source-code.com

Scripts.com
http://www.scripts.com

The ASP Resource Index
http://www.aspin.com

[Morgoth]

Every link above is excellent!

My favourite for all code is The ASP Resource Index http://www.aspin.com

When you finish your form, you will want to make sure it works before you add stuff like checking if a username is already in use, checking if they entered the same password in two text boxes, and same with e-mail with validating the e-mail.

A great function for validating e-mail is this one I was given by whammy (I think).

Function ValidateEmail(strEmail)
Dim strPattern
strPattern = "^[a-z0-9]+([-_\.]?[a-z0-9])+@[a-z0-9]+([-_\.]?[a-z0-9])+\.[a-z]{2,4}$"

Dim objRegExp
Set objRegExp = New RegExp
objRegExp.IgnoreCase = True
objRegExp.Pattern = strPattern

ValidateEmail = objRegExp.Test(strEmail)
Set objRegExp = Nothing
End Function

[startbar]

thanks, ive been having a good read of those.

is there any really easy to follow guides (for this subject) for newbies! i dont know much about asp!

thanks

[Morgoth]

I did a search in aspin.com, and found these two articles in a tutorial search.

http://www.planet-source-code.com/vb/scripts/ShowCode.asp?lngWId=4&txtCodeId=7225

http://www.planet-source-code.com/vb/scripts/ShowCode.asp?lngWId=4&txtCodeId=6948

Look at these, these might help you.