Access 2000 forms not updatable

re_anu · April 23rd, 2004, 11:05 AM

hi!

i have an adp project that is linked to SQL SERVER 2000. one of the forms has the record source set to a STORED PROCEDURE. if i use bound forms, and i try to update the records retrieved, i get an error RECORDSET NOT UPDATABLE. why? how do i get around this problem.

also i need to use a Stored Procedure, because, there is an input parameter, that is assigned during runtime.....

any help is greatly appreciated.PLEASE HELP.......

Steven · April 25th, 2004, 04:59 PM

One possible option is to use the concepts used with unbound forms with your bound forms.
For example, have an "Save/Update" button on the form, which, rather than a standard Save function, attach some SQL commands attached to it, such as:

Code:

DoCmd.RunSQL "UPDATE Table1 " _
  & "SET Field1 = '" & Form_Form1.Field1 & "', " _
  & "PatientId = '" & Form_Form1.Field2 & "' " _
  & "WHERE (((Table1.PRIMARYKEY)=" & Form_Form1.PrimaryKeyField & "));"

I am a loud man with a very large hat. This means I am in charge

Ben Horne · April 26th, 2004, 02:19 PM

Steven,

I don't think that the DoCmd statement would be acceptable SQL syntax. I might be wrong on this, though

scoxx · May 27th, 2004, 12:54 PM

Ever have any luck solving this issue??? It is something I am also experiencing and was wondering if perhaps you could share a workaround??? Thanks in advance

sal · May 28th, 2004, 10:44 PM

Stored procedures are not updatable. Use an updatable view instead.

Sal