[AccessD] Can't update view

David McAfee davidmcafee at gmail.com
Tue Mar 8 13:12:19 CST 2011


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?



More information about the AccessD mailing list