Hi all.
Here I am again, but not with a "what have I done wrong" question this time.
I have googled and read about recordsets, but I'm still unsure about WHAT they are. I find explanations on how to use them but until I know what it is then I don't really comprehend.
Am I correct if I say that they are a seperate entitiy from the tables and queries? If I declare a recordset, do I just make a link into the data that's a part of a table, sort of like a reference to is memory location, or is it a ghostly glob of data on it's own, to be used as a buffer between queries, tables and other database items?
Example: A simple database of 1 table. Which is closer...
Any helpful pointers for a thickie please please?
- The data in the table is stored in the table's recordset. I then access it by declaring a variable of type recordset? Or
- I create a recordset then copy the table data into it, effectively making 2 copies of the data, the recordset being a seperate item, not a reference?
- Something else?