Use dbOpenSnapshot when opening an recordset : Recordset Open « Access « VBA / Excel / Access / Word






Use dbOpenSnapshot when opening an recordset

 
Sub exaRecordsets()
    Dim db As Database
    Dim rsTable As Recordset
    Dim rsDyna As Recordset
    Dim rsSnap As Recordset
     
    Set db = CurrentDb
    Set rsTable = db.OpenRecordset("Employees")
    Debug.Print "TableCount: " & rsTable.RecordCount
    Set rsDyna = db.OpenRecordset("Employees", dbOpenDynaset)
    Debug.Print "DynaCount: " & rsDyna.RecordCount
    rsDyna.MoveLast
    Debug.Print "DynaCount: " & rsDyna.RecordCount
    Set rsSnap = db.OpenRecordset("Employees", dbOpenSnapshot)
    Debug.Print "SnapCount: " & rsSnap.RecordCount
    rsSnap.MoveLast
    Debug.Print "SnapCount: " & rsSnap.RecordCount
    rsTable.Close
    rsDyna.Close
    rsSnap.Close
 
End Sub

 








Related examples in the same category

1.Opening a DAO Recordset Using a Table
2.Connection error handler
3.Opening a DAO Recordset Using a SQL SELECT Statement
4.sets the locking type in the call to the Open method
5.Creating a Recordset Using a Connection String
6.Get Recordset content by calling Recordset.GetString
7.Creating a Recordset Using the ActiveConnection Property
8.Creating a Recordset Using a Connection Object
9.Opening a Recordset
10.Opening a Recordset Based on a Table or Query with SQL command
11.Recordset.Open method
12.Opening a Recordset Based on a Table or Query
13.Opening a Recordset Based on an SQL Statement
14.Opening a Recordset Based on Criteria
15.Opening a Recordset Directly
16.The RecordCount Property Is Not Supported with a Forward-Only Recordset
17.Options of Open Method: adCmdText - The provider evaluates the source as a command
18.adCmdTable - A SQL query is generated to return all rows from the table named in the source.
19.adCmdTableDirect - The provider returns all rows in the table named in the source.
20.adCmdStoredProc - The provider evaluates the source as a stored procedure.
21.adCmdUnknown - The type of command in the source is unknown.
22.adCmdFile - The source is evaluated as a persisted recordset.
23.adAsyncExecute - The source is executed asynchronously.
24.adAsyncFetch - The initial quantity specified in the Initial Fetch Size property is fetched.
25.adAsyncFetchNonBlocking - The main thread never blocks when fetching.
26.Opening a Recordset with Inconsistent Updates