Deleting from SQL table using a list box as reference

[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 idea

much appreciated

Dave

 

[shreked]

Here is microsoft fix for the problem

http://support.microsoft.com/support/kb/articles/Q190/6/20.asp

 

[daveonion]

shreked thanks for the post, but i am unsure as what i have to do wit hregards to microsoft access, any chance of enlightening me?

thanks