UPDATE and INSERT SQL questions

[cedx]

Hi,

How do I use UPDATE and INSERT type SQL statements in a database and recordset declared in code?

I use the following for SELECT statements:

SQL = "SELECT * FROM Employees"
Set db = OpenRecordset(dbPath)
Set rs = db.OpenRecordset(SQL)

I can't seems to get rs.Execute(SQL) to work. What am I doing wrong?

Thanks in advance.

[Nina]

StrSQL = "INSERT INTO " & Table_Name & _
                        " (" & StrFields & ") " & _
                        " VALUES (" & StrValues & ")"
'Debug.Print StrSQL

Dim cmd as ADODB.Command
Set cmd = New ADODB.Command
cmd.ActiveConnection = cnDB
cmd.CommandText = StrSQL
cmd.Execute
Set cmd = Nothing

[cedx]

Thanks Nina.

[honeybee]

I do it in DAO as this:

SQL = "Update ......"
dbMaster.Execute SQL

If you are not getting this right, maybe you are using parenthesis around the query, like:

SQL = "Update ...."
dbMaster.Execute(SQL)

Try omitting the parenthesis and it should work.