Re: This recordset is not updatable

[alicejwz]

Re: This recordset is not updatable

Hi all,

I created a form that links to a view. The view joins the two tables and both of these tables are defined w/ Primary keys. But when I try to update the table is giving an error in Access form: "This recordset is not updatable".
Would anyone have an explanation for this?
I'm using AC2K and SQL Server 2K.
Thanks!

 

[tjs206]

Views

Are you trying to update the tables themselves or are you trying to update the tables from the form to the tables via the view?

If it is the latter then the reason you are getting the error "This recordset is not updatable" is because you are trying to update through a view(query) which is not possible, you must update to the table directly. The view is only displaying the data from the 2 joined tables it does nothing more than that, unless you are working with action queries (Make Table, append, etc.).

Hope this helps.

 

[alicejwz]

Re: This recordset is not updatable

hi tjs206

Thanks for your explanations. I was trying to update a table thru the view in the form. Does it make a difference the view is in Access or SQL Server? I thought it worked before in Access.

 

[tjs206]

It doesn't work for any version of Access or SQL Server that I am aware of. I have never actually run into this problem, but I took a designer class on SQL 2K and one of the big notes the instructor said was that you can not update underlying tables through a view, unless, of course, as I mentioned before it is an action query.

Maybe if you can explain what you are trying to accomplish I could help you with a work around. I have used queries in forms before, but it is usually for combo boxes and subforms, things like that.

Hope this helps. I will monitor this message board for your reply.

 

[alicejwz]

Re: This recordset is not updatable.

Thanks tjs206 and Pat for your replies.
I might be the queries instead view that worked.
So how would you to display data from more than one table in an Access form using SQL Server tables and also edit a table?

Thanks!

 

[alicejwz]

Re: This recordset is not updatable

Hi Pat,

I do have an aggregate function in my query. Is there a way I can get around it?
Thanks!