Mr Khan:

From your lesson on adding records to the database, are the codes for the "Via Connection Object" and "Via Recordset Object", the complete ones? Meaning, do I just have to copy and paste any one of these on notepad, rename rename it (with an .asp extension), and drop it into my inetpub/wwwroot? Moreover, I also have had created my dbase and have it connected on my system DSN. I named my DSN, "dbinsert". One thing that I am not sure is where do I put my DSN within the codes on either connection object or recordset?

I liked your lesson on accessing dbases from asp, it was that step by step process that helped me a lot.

I can't get this to work. Help?!

-Roger

You'll have to change the following in the code:

data_source = myDSN

to:

data_source = "DSN=dbinsert"

And there you go, if you have setup everything correctly the code should work.

That DSN thing is not necessarily required, you can use a connection string instead. For more details read this article: http://www.stardeveloper.com/articles/display.html?article=2000120101&page=1