Not a simple answer to this one!!
1. Have you set up a DSN to link to your database?
2. If not #1, are you planning on using a DSN-less connection (a good idea if your web application is expecting a lot of hits or is on your ISP's sever - ISP's may frown on having to set up and maintain your own DSN's).
3. You have to set up a connection to your database, a sample of code you may wish to use is displayed below:
*****************************
dim dbMyConnection
dim rstMyTable
dim strSQL
set dbMyConnection = Server.CreateObject("ADODB.Connection")
set rstMyTable = Server.CreateObject("ADODB.Recordset")
MyConnection.Open "Data Source=" & Server.MapPath("Mydatabase.mdb") & ";Provider=Microsoft.Jet.OLEDB.4.0;"
strSQL = "Select * From [MyTable]"
rstMyTable.Open strSQL, dbMyConnection, adOpenStatic, adLockOptimistic
rstMyTable.AddNew
rstMyTable("Field 1") = "My First Data"
rstMyTable.Update
rstMyTable.Close
dbMyConnection.Close
*****************************
The above snippet of code is just a guideline. Try it out and modify table and variable names to suit your own needs.
P.S. Make sure that you create an include at the beginning of your ASP page that includes the "adovbs.inc" file if you are going to be using constants like "adOpenStatic" and "adLockOptimistic" instead of their numerical counterparts.
Let me know how you make out with this.