• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Chapter 30. Working with Recordsets and ... > Modifying Rows of Recordsets

Modifying Rows of Recordsets

You can perform CRUD (Create, Read, Update, and Delete) operations on most dynamic Recordsets with VBA code. To test whether a Recordset is editable, check the value of the Updatable property. You can't edit Forward-Only or Snapshot-type Recordsets, and most dynamic queries with INNER or OUTER JOINs aren't editable.

Caution

Don't apply Edit, AddNew, Update, or Delete methods to a Recordset created from the tables of your original Northwind.mdb file. Make a copy of the file in another folder.



PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint