ADODB Recrodset (Understanding)

[danny2000]

Before I start, this is not homework. I'm well past that. I'm genuinely trying to understand the concept behind a Recordset used in Microsoft access.



My assumption is that a Recordset is a snapshot of a query to a database. Thats the original database I am querying. I'm also of the understanding that I can update that database from the Recordset itself and that is determined by the 'cursor type' I select when I create the Recordset.

Is this correct? OR is there no connectivity back to the original database I sourced my data from which is displayed via the Recordset?

It would be fantastic if someone could clear that up for me.

Thanks so much.

[orange]

Here's a description via Google.
http://www.aspfree.com/c/a/Microsoft...ccess-and-ADO/

and here's a fuller description by Allen Browne
http://allenbrowne.com/ser-29.html

[danny2000]

Here's a description via Google.
http://www.aspfree.com/c/a/Microsoft...ccess-and-ADO/

and here's a fuller description by Allen Browne
http://allenbrowne.com/ser-29.html

Thanks for that. These explanations are great.
I'm basically trying to understand whether any recordset is a live connection back to the original database. Meaning, if I update the recordset or manipulate data provided by a query am I actually amending the source of that data as well. I'm assuming that is why there are different cursor types. Can you confirm this.

Thanks again.

[orange]

see http://www.aspfree.com/c/a/Microsoft...ccess-and-ADO/