Editable Views

J

Joe Delphi

Hi,

I have an MS Access 2002 application that talks to MS SQL Server on
the backend. I have a view that I want to be editable and have done
everything to make it that way (I think), but still cannot edit it. I open
the view using the OpenView "ViewName", acNormal, acEditable but if I
attempt to change anything in the resulting datasheet, it tells me that
"This recordset cannot be edited"

The view is created from a single table and that underlying table
has all of the permissions necessary for editing, SELECT, INSERT, UPDATE,
DELETE

Any suggestions?

JD
 
T

Tom Wickerath

Hi Joe,

Does the table include a primary key or unique index?

Tom
_______________________________________

:

Hi,

I have an MS Access 2002 application that talks to MS SQL Server on
the backend. I have a view that I want to be editable and have done
everything to make it that way (I think), but still cannot edit it. I open
the view using the OpenView "ViewName", acNormal, acEditable but if I
attempt to change anything in the resulting datasheet, it tells me that
"This recordset cannot be edited"

The view is created from a single table and that underlying table
has all of the permissions necessary for editing, SELECT, INSERT, UPDATE,
DELETE

Any suggestions?

JD
 
Top