MS Access 2002 / MS SQL 2008 R2 - Problems deleting records based on certain criteria -

i'm trying code delete records access 2002 database table linked ms sql 2008 database table through form event. want delete records user null , date null.

here's snippet that's giving me trouble:

dim delsql string  docmd.setwarnings false delsql = "delete * notifications user isnull;" set rst = currentdb.openrecordset(delsql, dbopensnapshot)  docmd.runsql delsql rst.close set rst = nothing docmd.setwarnings true 

i don't know why isn't working. ran sql statement above (not including date part wanted user criteria working first) on sql server side , works. every time try run in vba access 2002, error when goes execute sql.

user reserved word. either enclose in square brackets, or qualify field name table name or alias.

isnull function. either use is null @alexk. suggested or use field name argument isnull().

the * in delete * not required. access not throw error if include it. , can useful when wish preview affected rows in access query designer's datasheet view.

delsql = "delete * notifications n n.user null" 

i suggest leave setwarnings on, , use currentdb.execute dbfailonerror execute delete. since data source linked sql server table, include dbseechanges:

docmd.setwarnings true currentdb.execute delsql, dbseechanges + dbfailonerror 

that approach give better information problems encountered.