Frontpage 2002 and ASP help please

Hi. Ive been using frontpage 2002 for my databse but would love to know more about ASP. Frontpage can generate asp codes but can anybody help how to use frontpage and at the same time create my own ASP codes for viewing database in ACCESS, add, edit, delete, update database. Also I tried using Frontpage for my database, but the problem is i cannt edit the codes for its so complicated. what i wold like to perform is view the database in access in my browser, update on it, delete a record, edit it, and when adding new record, a new number for the applicant[its like auto number, i tired using ACCESS to auto number, its nice nice. =) i know there is a a way by using ASP.]. thanks so much. hope to hear from you guys.

dip

Um, don't use frontpage's generated asp code, its not very good. The way I do asp in frontpage is to write it all in the html view, and only really use frontpage for some simple html. Not completely sure what you meant with the rest of your question. You can modify and view databases using asp, look for some online tutorials on asp and sql.
HTH

hi. you are very right. using frontpage's code makes life complicated. i would love to learn basic asp by entering the codes in html view. i want to perform the ff: view my database i made in ACCESS. add, edit, delete, update. im working on an online application form, i used to have access AUTO number my applicants, is there a way where i can do this in ASP? i know there is. any help is acceptable. thanks!

I'm sorry, i don't understand, can you rephrase?

you have an autoincrementing column and you need to get that value? Do you have any other unique identifier to grab that row? IF now you'll need to use multiple colums to identify the row.

with frontpage i just have in normal view, and i insert form elements that way, then go to html view to add the values and default, and stuff that way

Don't use frontpage to access the DB, it's impossible to update, well possible, but retardedly difficult to update (did you set up the DB yourself? if you did you should know the auto number field and how to identify it).

Please ask questions but as of right now i can't understand what you need help with (besides learning not to use frontpage )

You can do all the adding, editing, updating, etc using sql queries from an asp page. Search google for tutorials about connecting to a database using asp, there's tons of them out there.
You can still have access autonumber you applicants, just have an autonumber column, and all the applications that are added to the database will be autonumbered, just like if you were adding them in access yourself.
HTH
Dave