A table-type Recordset object contains these collections, methods, and properties. This type of Recordset and its methods and properties are available only in a Microsoft Jet workspace.
Collections
| Fields (default) |
| Properties |
Methods
| AddNew |
| CancelUpdate |
| Clone |
| Close |
| Delete |
| Edit |
| GetRows |
| Move |
| MoveFirst |
| MoveLast |
| MoveNext |
| MovePrevious |
| OpenRecordset |
| Seek |
| Update |
Properties
The following table indicates whether each property setting is read/write, read-only, or always False.
Read-only
Read/write
| Properties | Restrictions |
| BOF | ![]() |
| Bookmark | ![]() |
| Bookmarkable | ![]() |
| DateCreated | ![]() |
| EditMode | ![]() |
| EOF | ![]() |
| Index | ![]() |
| LastModified | ![]() |
| LastUpdated | ![]() |
| LockEdits | ![]() |
| Name | ![]() |
| NoMatch | ![]() |
| PercentPosition | ![]() |
| RecordCount | ![]() |
| Restartable | Always False |
| Transactions | ![]() ![]() |
| Type | ![]() |
| Updatable | ![]() |
| ValidationRule | ![]() |
| ValidationText | ![]() |