J
jim
Hi,
I'm using Access as a proxy to transfer content from a series of
SharePoint lists into a MySQL database. Append queries I run weekly
work just fine, but an Update query fails every time since the first.
I've tried a few solutions found scouring Google (e.g. removing the
text PK, increasing INT sizes), but nothing seems to help.
Update will always work the first time if I recreate the database.
Once run, however, it returns an error because of lock violations.
Any ideas how to resolve this?
Thanks in advance.
Jim
I'm using Access as a proxy to transfer content from a series of
SharePoint lists into a MySQL database. Append queries I run weekly
work just fine, but an Update query fails every time since the first.
I've tried a few solutions found scouring Google (e.g. removing the
text PK, increasing INT sizes), but nothing seems to help.
Update will always work the first time if I recreate the database.
Once run, however, it returns an error because of lock violations.
Any ideas how to resolve this?
Thanks in advance.
Jim