I've tried to get the following to work, could anyone tell me how I could use a pre-decided set of cells such as A1 B1 C1 D1?
Const TARGET_DB = "testdb.accdb"
Sub AlterOneRecord()
Dim cnn As ADODB.Connection
Dim rst As ADODB.Recordset
Dim fld As ADODB.Field
Dim MyConn
Dim...