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