Data Updation / Adding problem using ASP.

[monte96]

Dim cnConn
Dim strConnect
Dim rs

strConnect = "Provider=Microsoft.Jet.OLEDB.4.0;" & "Data Source=C:\yourdatabase.mdb;"

Set cnConn = Server.CreateObject("ADODB.Connection")
cnConn.ConnectionString = strConnect
cnConn.Open

BTW- the concept of an updateable database does not work well with ASP. The reason is that in order to read the records in and allow editing and then write the changes, requires at least two trips to the server. Since the recordset you define when you open for reading is only valid during that page's execution, once the EU modifies and submits changes, essentially another separate connection needs to be opened and used to write the changes to the database. The best solution I think is using update statements to change the data in the database. You have to remember that ASP and the web in general is stateless. Which means you can not open a recordset and use it throughout many pages (You can through the Session object but that adds a whole new set of problems and should be avoided).