UPDATE and INSERT SQL questions

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:

Code:

---

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.

Code:

---


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

---

Thanks Nina.

I do it in DAO as this:

Code:

---

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

---

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

Code:

---

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

---

Try omitting the parenthesis and it should work.