Opening a Recordset with Inconsistent Updates : Recordset Open « Access « VBA / Excel / Access / Word

Home
VBA / Excel / Access / Word
1.Access
2.Application
3.Data Type
4.Data Type Functions
5.Date Functions
6.Excel
7.File Path
8.Forms
9.Language Basics
10.Math Functions
11.Outlook
12.PowerPoint
13.String Functions
14.Windows API
15.Word
16.XML
VBA / Excel / Access / Word » Access » Recordset Open 




Opening a Recordset with Inconsistent Updates
 
Sub InconsistentUpdates()
    Dim rst As ADODB.Recordset
    Set rst = New ADODB.Recordset

    rst.ActiveConnection = CurrentProject.Connection
    rst.CursorType = adOpenStatic
    rst.LockType = adLockOptimistic

    rst.Properties("Jet OLEDB:Inconsistent"= True
    rst.Open Source:="Select * from Employees " & _
        "INNER JOIN Projects " & _
        "ON Employees.ClientID = Projects.ClientID", _
        Options:=adCmdText

    rst("Projects.ClientID"1
    rst.Update
    Debug.Print rst("Projects.ClientID")

    rst.Close
    Set rst = Nothing

End Sub

 














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