Delete Access query object [Resolved]

[Shawn N]

Try this:

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[qryIDCount]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[qryIDCount]
GO