Home Forums Microsoft Access Microsoft Access Access 2003 ADP runs SQL 2005 SP to selectively delete rows - does not remove any rows RE: Access 2003 ADP runs SQL 2005 SP to selectively delete rows - does not remove any rows

  • Thanks.

    The SP is simply Delete from tablename where codefield = 'C'

    I've thought it was permissions all along, but I can't find any that are not set properly.

    The users are all PUBLIC

    Public has EXECUTE rights on the SP

    Public has ALL rights on the table (Delete Insert Select Update)

    Is there anything about launching it from Access-VBA I should know?

    BTW: All my other SPs (non-delete) run fine launched from Access ADP.