Opening A table to Update

[coughnut]

I want to open two table and want to be able to update one table. So far here is what I am doing to open one table:

Dim rsTemp As New ADODB.Recordset

rsTemp.Open "SELECT * FROM tempTable", CurrentProject.Connection, adOpenKeyset, adLockOptimistic

Help please....

 

[Remou]

How about

Dim rst As ADODB.Recordset
Dim strSQL As String

Set conDatabase = CurrentProject.Connection
Set rst = New Recordset
strSQL = "SELECT * FROM tempTable"

rst.Open strSQL, conDatabase, adOpenDynamic, adLockOptimistic

 

[Remou]

Oops, I think you wanted:
rst.Open strSQL, conDatabase, [blue]adOpenKeyset[/blue], adLockOptimistic

 

[coughnut]

Thank you so very much.. I will sure try that...