Help with Syntax on db delete using ID (resolved)

[ARPRINCE]

Do you get the same error message as with your first post on this revised code?

'This does NOT work
dim test as string
test = "1"
Set MyRecSet = MyConn.Execute("DELETE * FROM table1 WHERE ID = " & test)