PDA

View Full Version : update & insert operation, asp, vbscript, Ms Acce



Dilruba
11-12-2007, 03:14 PM
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