How to use a SQL stored procedure to poulate and then edit a form
Posted on 2011-03-12
I have an adp and I am trying to use a stored procedure for the record source of a form. It has a parameter and it works fine for displaying the record I want. I am not able to edit the form unless I am logged in with an account that is a memeber of db_owner. Otherwise I get "This Recordset is not updateable" when I try and type something in a text field. I have given the user account execute permissions on the sproc and also added it to the db_datawriter role. I have coded the update sproc to a button and use it to perform edits.
Is it possible to use a sproc in the manner I am attempting or maybe I need to use an unbound form and populate it using an adodb recorset?