Updateable views for MS Access 1

[itsgoodtobeking]

Can anyone tell me how to make a view updateable in MS Access? I have made a view and can see the view in a form in Access (.adp), but cannot change any data. I have set all the permissions in SQL server for the user to have full access to the table.

 

[SQLSister]

WHether a view is updateable depends on many things. If you use an agreegate function in it the view is not updateable. If you have a SQL Server backend and an Accesss front end, the table must have a primary key or other unique identifier to be updateable.

Even if the view is updateable, you cannot update mutiple tables in one step, so it is stiul best to update tables through stored procedures and not to use views for this.

Lok at views-SQL Server, Modifyng data in BOL for the rules on updating and inserting to views.

Questions about posting. See faq183-874

 

[itsgoodtobeking]

Thanks I think I have it now. I don't believe there is any unique id's on any of the tables here.

I will try to add the id's on the tables