query does not delete in access 2002

[keyword]

My delete query doesn't work since I moved application to access2002. I get a warning message that I am about to delete rows, I click OK and then get message that rows have been deleted. When I look at the table the rows are still there. This delete query worked in access97

 

[JPeters]

You need to turn your warnings off prior to running the query. If you are runnin this query manually via double clicking it - you can go to Access' options menu and turn them off there. This will turn them off client side, not DB side.

If you wish to turn them off in the DB and you are running the query via code, simply do this

DoCmd.SetWarnings False
DoCmd.OpenQuery "qryUpdateQuery"
DoCmd.OpenQuery "qryQueryName"
DoCmd.SetWarnings True

... Change the query names, you get the idea. ;-)

-Josh ------------------
-JPeters
Got a helpful tip for Access Users? Check out and contribute to 'How to Keep Your Databases from becoming Overwhelming!'
thread181-293590
jpeters@guidemail.com
------------------