Access - ADODB.RECORDSET

[MrDeej]

Hello!

Question:

I always modify and add posts i tables using this code:

Dim Rst as New Adodb.Recordset

RST.open "SELECT * sometable",CurrentProject.Connection, adOpenDynamic, adLockOptimistic



But you can also Dim RST without the "New" part and at RST.open "SELECT * sometable", you can choose some different endings of the sentence.

What does "CurrentProject.Connection, adOpenDynamic, adLockOptimistic" and why was i learned to use this frase?
And what does Dim RST as NEW Adodb.recordset mean?

the reason for asking is that it is maybe a better way to do things, maybe even a way that uses less CPU power. I have noticed that when i have rather large table updates using this code access sometimes freezes up for a short time.

- Eirik

[ADezii]

Hello!

Question:

I always modify and add posts i tables using this code:

Dim Rst as New Adodb.Recordset

RST.open "SELECT * sometable",CurrentProject.Connection, adOpenDynamic, adLockOptimistic



But you can also Dim RST without the "New" part and at RST.open "SELECT * sometable", you can choose some different endings of the sentence.

What does "CurrentProject.Connection, adOpenDynamic, adLockOptimistic" and why was i learned to use this frase?
And what does Dim RST as NEW Adodb.recordset mean?

the reason for asking is that it is maybe a better way to do things, maybe even a way that uses less CPU power. I have noticed that when i have rather large table updates using this code access sometimes freezes up for a short time.

- Eirik

1. What you are describing are all Arguments to the Open Method of an ADO Recordset Object.
   1. CurrentProject.Connection ==> a valid Connection Object Variable.
   2. adOpenDynamic ==> the Type of Cursor the Provider should use when opening the ADO Recordset.
   3. adLockOptimistic ==> the specific Type of Locking employed on the Recordset.
2. Dim RST as NEW Adodb.Recordset => you are creating a New Instance of an ADO Recordset, and storing it in the Object Variable RST.