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!You can only update columns in the view from one table with one update statement. You can only update columns if you have all of the columns in the declared PK for the table in the view.

-PatP

RC2 - 128 bits?

Does SQL 2005 RC2 provide 128 bit keys on Windows 2000? Or is it limited to
40 bits on Windows 2000?
Thanks"Mike C#" <xyz@.xyz.com> wrote in message
news:%23GlmT6kSHHA.412@.TK2MSFTNGP02.phx.gbl...
> Does SQL 2005 RC2 provide 128 bit keys on Windows 2000? Or is it limited
> to 40 bits on Windows 2000?
And by the way, does SQL Server Triple_DES encryption use the EDE mode?
Thanks