What is recordset

At any time, the Recordset object refers to only a single record within the set as the current record. We're doing our best to make sure our content is useful, accurate and safe. If by any chance you spot an inappropriate comment while navigating through our website please use this form to let us know, and we'll take care of it shortly.

Forgot your password? Retrieve it. If by any chance you spot an inappropriate image within your search results please use this form to let us know, and we'll take care of it shortly. Term » Definition. Word in Definition. Wiktionary 0. Freebase 0. How to pronounce recordset? Alex US English. David US English. Mark US English. Daniel British. Libby British. Mia British. In this sense, recordset is nothing more than a generic term used to refer to the result of a particular search.

Once generated, recordsets only refer to one individual record within the database as the "current record. They exist by themselves as separate entities hosting the desired information, while the rest of the database records and files remain intact and untouched.

As a result, modifying the information stored in recordsets will not affect the corresponding information contained in the actual database tables. Please enter the following code:. A Dynaset may be a query. That was defined in a access of table of result of joining multiple tables. Like a table, a Dynaset is updatable if file is not locked or open for read only.

Data in Dynaset is live that is any changes made to data as project is executing will appear in Record Set. Snapshot Record Set, like a dynaset, may be taken from one or more table.