update & insert operation, asp, vbscript, Ms Acce

[Dilruba]

I have used the following codes:

connectionString = "DRIVER={Microsoft Access Driver (*.mdb)};DBQ=c:\progam files\mail.mdb"


‘ execute the update

Set MM_editCmd = Server.CreateObject("ADODB.Command")

   MM_editCmd.ActiveConnection = ConnectionDb

   MM_editCmd.CommandText = sql

    MM_editCmd.Execute 

    MM_editCmd.ActiveConnection.Close