sql server data not updatable

  • Thread starter Thread starter Hans Mol
  • Start date Start date
H

Hans Mol

when connecting to a sql server by means of ODBC I can do anything with the
tabels but the views I made on the sql server are not updatable.
I even made a view with one table and one field and one record, when
connecting again, even this view was not updatable and I am sure all the
rights on the tables are ok.
 
Hans Mol said:
when connecting to a sql server by means of ODBC I can do anything with the
tabels but the views I made on the sql server are not updatable.
I even made a view with one table and one field and one record, when
connecting again, even this view was not updatable and I am sure all the
rights on the tables are ok.

The Primary Key of the table the View is based on will not be "seen" as the PK
by Access. When you create the link you should get a prompt asking you to
define the field(s) to use for a local unique index. Doing that should make the
View editable. If you later refresh that link though the local index
information will be lost and the link will revert to read only.
 
Back
Top