Hi Bill,
Thanks. At this point I'm willing to try anything. I can append edit and delete within SharePoint. and sporatically via the Access Query. What kills me is that this is the only list that I'm accessing in Sharepoint where this issue happens.
If I do get a fix, I'll update this posting with the solution.
--- In MS_Access_Professionals@yahoogroups.com, "Bill Mosca" <wrmosca@...> wrote:
>
> Frank
>
> SharePoint is still not a good place for a relational database. I haven't worked with it, but the folks I know who have have also faced these kinds of obstacles.
>
> My suggestion is to first check your permissions to see if you can append/edit/delete.
>
> If that doesn't help, you might want to post to a SharePoint group (not that I'm trying to drive you away).
>
> Regards,
> Bill Mosca, Founder - MS_Access_Professionals
> http://www.thatlldoit.com
> Microsoft Office Access MVP
> https://mvp.support.microsoft.com/profile/Bill.Mosca
>
>
>
>
> --- In MS_Access_Professionals@yahoogroups.com, "frank_guasp" <fguasp@> wrote:
> >
> > I recently migrated an application to Access 2007.
> > The Backend Tables are housed as lists in Sharepoint.
> > I have full access to those lists
> >
> > I'm running a query that appends a record to this list and I get the following MSG: Operation must use updatable Query.
> > I don't what to do. It happens sporatically. There are no other users
> >
> > I have a unique field (Sharepoint ID is unique)
> > I've tried it via a query and via SQL Code and they both work spratically. What am I missing.
> >
> > This query used to work when I had the table housed on a SQL Server.
> > I don't know what to do.
> > HELP!! I'm loosing my mind
> >
>
Tidak ada komentar:
Posting Komentar