[AccessD] Can't update view

It had me confused too.

The other developer tends to not use PKs (or uses a lot of multi-natural key
indexes) so I figured that's what it was.

I was too swamped today to give it any more time than I did.

He had the view bound form working by giving rights to the table, so it
wasn't like he was down.

I let him borrow my Susan & Martin book (as I like to call it) and showed
him the part in the book for possible reasons.

D

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

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