error when using code to delete from sql table within access

[daveonion]

Hi i've got the following code,

CurrentDb.Execute "Delete * From dbo_tbl_poster Where dbo_tbl_poster.[ris_poster_risuid] = '" & Me.uid_scf & "'"

to delete an entry out of a table, the table is attached to sql server and when i execute the code the following error occurs

You must use the dbSeeChanges option with OpenRecordset when accessing a SQL Server table that has an IDENTITY column. (Error 3622)

anybody out there have any ideas

much appreciated

Dave