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