<QUOTE>
Ms Access
using ADO you can write the following code
Public dbase As New ADODB.Connectio n
Public rsconn As New ADODB.Recordset
Set dbase = New ADODB.Connectio n
dbase.Open "Provider=Micro soft.Jet.OLEDB. 4.0;Data Source=" & App.Path & "\databaseName. mdb"
Set rsconn = New ADODB.Recordset
Set rsconn = dbase.Execute(" UPDATE tableName SET field1 = '"...