[AccessD] Can't update view

David,
Looks like that you have a "broken ownership chain".
If the owner of the table is the same as the owner of the view then you can give privileges to the view without having to give privileges to the table.
If however the table has an owner different from the owner of the view then the "ownership chain" is "broken" and you have to give explicit privileges on the table itself.
That's why it's best practice use the same owner (normally dbo) for all objects in the database.
Did you check the owner of the table and the view? You can do this in Sql Server Management Studio using this command in a query window:
EXEC SP_HELP 'name of table or view'

Asger

-----Oprindelig meddelelse-----
Fra: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] På vegne af David McAfee
Sendt: 8. marts 2011 20:12
Til: Access Developers discussion and problem solving
Emne: [AccessD] Can't update view

I have a coworker that is using an Access 2003 ADP.

In the ADP he has a form which is bound to a view which is only selecting
from one table.

The View is not updateable unless he also gives update privileges to the
role at the table level.

The table does have a PK. Does the view need a unique index as well?

I always use stored procedure and unbound forms, so I never run into this.


Any ideas?
-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com