[AccessD] Can't update view

Asger Blond ab-mi at post3.tele.dk
Tue Mar 8 18:34:25 CST 2011


Fine. Haven't used this option so far - interesting, will remember it for future cases.
Asger

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

They got it going using

CREATE VIEW vwViewName WITH VIEW_METADATA AS ...




On Tue, Mar 8, 2011 at 3:29 PM, Asger Blond <ab-mi at post3.tele.dk> wrote:

> 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
>
>
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>
-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com





More information about the AccessD mailing list