Form is read-only because of stored procedure

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: Eric (eshears_at_tcac.org)
Date: 03/08/04 

Date: 8 Mar 2004 12:50:32 -0800

I have a stored procedure that yields the records I want, but when I
attempt to edit those records in a form, I am unable to do so.
Apparently the recordset is read-only because it is based on a few
related tables. To throw an additional wrench in the works, the
stored procedure as a parameter. I've attempted to use the
UniqueTable/Resync stuff, but am not sure what to do with it. Thanks
in advance for any help.

Relevant Pages

  • Re: SQL Server 2005 - Cant edit results from stored procedure
    ... > then run a stored procedure that returned data from a 2 table select ... > statement and edit the data. ... I don't use Enterprise Manager much but I'd be surprised if it's possible to ... SQL Server MVP ...
    (microsoft.public.sqlserver)
  • Editing of custom stored procedures.
    ... I was wondering about best practise to edit custom stored procedures. ... Setting up article with custom stored procedure for insert ... Run the snapshot agent. ... Go to the snapshot folder and open the .sch-file and edit the ...
    (microsoft.public.sqlserver.replication)
  • Re: Form is read-only because of stored procedure
    ... >attempt to edit those records in a form, I am unable to do so. ... some more information about the stored procedure (where it's ... your database. ... Come for live chats every Tuesday and Thursday ...
    (microsoft.public.access.forms)
  • DataGrid Edit/Update problem
    ... DataGrid so that you can Edit, Update, Cancel. ... Stored Procedure only updates certain columns I would like to make ... System.Web.UI.WebControls.TextBox cName = new ...
    (microsoft.public.dotnet.framework.aspnet)
  • DataGrid Edit/Update problem
    ... DataGrid so that you can Edit, Update, Cancel. ... Stored Procedure only updates certain columns I would like to make ... System.Web.UI.WebControls.TextBox cName = new ...
    (microsoft.public.dotnet.framework.adonet)