SQL Server 2000, dbSeechanges, and Delete

[lyners]

Is there a way to pass a delete query through to SQL server from Access
2000 so I do not get the dreaded 3266 dbSeeChanges error?



In short I have:



Currentdb.execute ("Delete * from TestTable where Col1 = '1'")



I get a dbSeechanges error (Must have the options set up for
dbSeechanges), if I change my CurrentDb.execute line to:



Currentdb.execute ("Delete * from TestTable where Col1 = '1'",
dbSeechanges)



I get a "Expected =" error.



Currently I have the code loop through the SQL table to delete the
records. It is VERY SLOW! I would rather let the SQL Server handle the
delete by passing it a query.



Thoughts, comments, and possible solutions would be great.



Thanks!

Lyners

 

[John Viescas]

Get rid of the parens:

Currentdb.execute "Delete * from TestTable where Col1 = '1'", dbSeechanges


--
John Viescas, author
"Microsoft Office Access 2003 Inside Out"
"Running Microsoft Access 2000"
"SQL Queries for Mere Mortals"
http://www.viescas.com/
(Microsoft Access MVP since 1993)
http://www.deanforamerica.com/site/TR?pg=personal&fr_id=1090&px=1434411

 

[lyners]

Too easy.... Thanks, works great!