Sharepoint Delete Issue

[Leesha]

Hi,
I have an Access database that is linked to a Sharepoint list/table. It is set to delete data and append new data each day. This has been working fine for quite a while. Recently the database was moved to a different location. Ever since that time, the database blows up when the delete query is run. I am able to manually access the data in the linked Sharepoint file and can manually edit it. The file contains 3171 records which is roughly the size it's always been. I've compacted and repaired the DB but still have the same result. I'm not sure what is causing it to blow up every time the delete query is run. This is what I'm using:

DELETE tblContactInfoSharepoint.*
FROM tblContactInfoSharepoint;

Thanks,
Leesha

[HansV]

Have you tried refreshing the link, or even deleting it and creating it again?

[Leesha]

Hi Hans,
No I haven't since I can open it from Access and can edit the data. Will give that a try.
Thanks!
Leesha

[Leesha]

Hi Hans,
Unfortunately refreshing and recreating didn't fix the issue. I'm wondering if it is a permissions issue. I did not set up the Sharepoint list, and am only marginally familiar with Sharepoint.
Leesha

[HansV]

I'm sorry, I'm not familiar with SharePoint at all.

[Gasman]

Can you delete a record manually?

[Leesha]

I've tried manually and am unable to delete. I can open the list, can change the data, but when I tab off of the change, the database blows up.It only appears that the data is being changed.

[Gasman]

So it might be a permissions issue?
I have never used Sharepoint, so I cannot help with that sorry, but your fault lies with unable to delete, not your query.

[Leesha]

Thanks everyone!

[George Hepworth]

That sounds to me like a permissions problem, especially since "Recently the database was moved to a different location. "

What else might have changed? Have you asked the SharePoint admin for your organization for assistance?

[Leesha]

It did end up being a permission issue. Once permission was re-granted on the new computer the issue tesolved.

[HansV]

Good to hear that!