Ms access current recordset does not support updating
The recordset interface is referred to as Active X Data Objects (ADO).
It requires a different syntax than DAO, but your experience with DAO will transfer nicely, and it has a much more powerful and consistent toolkit for accessing today's variety of PC and mainframe database formats on the Web.
This is the starting place for both DAO and ADO recordset methods. Open "SELECT * FROM tbl Sample", Obj Conn, ad Open Keyset, ad Lock Pessimistic, ad Cmd Text This Cursor Type uses a dynamic cursor. This improves performance when you need to make only one pass through a recordset. The server does what is necessary to ensure successful editing of the records, usually by locking records at the data source immediately after editing. Find "pk People ID=2", , ad Search Forward ' numeric constant - ADO rs.
And you can copy and paste the data used in the examples from the table below.pk People ID First Name Last Name Hire Review Salary Sex Is Selected 1 Carla Dumont 9/4/87 10/2/99 ,249.82 F Yes 2 Andrew Frank 2/9/97 2/9/99 ,081.10 M Yes 3 Janet Lydell 6/25/94 6/25/99 ,875.00 F No 4 Margo Oniell 1/16/94 7/16/99 ,629.58 F Yes 5 Edward Jones 1/17/98 9/17/99 ,163.31 M No 6 Harry Jones 9/22/78 10/1/99 3,500.00 M Yes 7 Jane Doe 8/9/78 10/3/99 3,750.00 F Yes 8 Hugh Poynor 9/12/89 9/30/99 ,601.00 M No 9 Jane Deaux 9/8/87 10/3/99 ,368.71 F Yes If you have this document open, highlight all 9 data rows (above) and copy them to the clipboard.