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.