Monday, February 13, 2012

2005 Express - SPs read-only

I am attempting to use a select SP with params to return data to MS Access. I am using SQL Server Management Express to manage SQL Server 2005. I can create tables, views and SPs just fine. Tables and views return data that is r/w but ALL SELECT SPs return data that is Read Only. Is this normal? I am under the impression that SPs can be used to return data to Access forms which is updateable, but I cannot even edit the data for an SP directly out in SMSE, never mind in Access.

TIA for any assistance on this,

John W. ColbyIf I understand your question properly, you are using a stored procedure to return a data set to a Microsoft Access form. If that is the case, then the result set is not updateable. In other words, you can't run a stored procedure, get some data, and then update that data on the screen and expect it to change in the database. You would need to code another stored procedure to take the updates and perform an UPDATE or INSERT statement back to the database from your Access form.

No comments:

Post a Comment