Using Access 2010 and SharePoint 2010
We have been using linked SharePoint list in an Access 2010 application for a few months now. We have been able to work through several issues and have been successful with the implementation of using Access to update records in the SharePoint list using VBA to iterate through recodsets.
We have occasionally had a situation where one record in the SharePoint list would not let us update any fields using the same VBA code. Because this seemed to only affect one single record, when we had identified the record, we simply added code to exclude that one record. However, as of today, we suddenly are having this same issue with multiple, random records. These records will be one single record in the recordset or they may be 4 or 5 records in sequence. No error is reported from VBA but the execution of the code just stops. If I step through the process, it locks up when it tries to assign the first value to the first field that it is supposed to write a value to.
What is even more strange, is that the same records that we cannot write to from Access (directly in the lined table or through VBA) can be modified from the datasheet view in the SharePoint site.
I though I would see if any of you have experienced anything like this. It almost seems that the link from Access to the SharePoint list is not allowing the editing of random records for no apparent reason.
Any thoughts or assistance will be appreciated.
We have been using linked SharePoint list in an Access 2010 application for a few months now. We have been able to work through several issues and have been successful with the implementation of using Access to update records in the SharePoint list using VBA to iterate through recodsets.
We have occasionally had a situation where one record in the SharePoint list would not let us update any fields using the same VBA code. Because this seemed to only affect one single record, when we had identified the record, we simply added code to exclude that one record. However, as of today, we suddenly are having this same issue with multiple, random records. These records will be one single record in the recordset or they may be 4 or 5 records in sequence. No error is reported from VBA but the execution of the code just stops. If I step through the process, it locks up when it tries to assign the first value to the first field that it is supposed to write a value to.
What is even more strange, is that the same records that we cannot write to from Access (directly in the lined table or through VBA) can be modified from the datasheet view in the SharePoint site.
I though I would see if any of you have experienced anything like this. It almost seems that the link from Access to the SharePoint list is not allowing the editing of random records for no apparent reason.
Any thoughts or assistance will be appreciated.