<div>
<div class="content wysiwyg-content">
Hello. Hoping someone can point me in the right direction. We recently began experimenting with Sharepoint List integration using Sharepoint Online and Office 365. Since integration with Access Desktop Apps was built in, we started there. I have a simple SharePoint list for tasking that was customized to add a few additional fields. Periodically, while using vba to update the Sharepoint List, it will cause Access to crash. The Event Log references an ntdll.dll error and sometimes an ACEWSS.DLL error. <br />
<br />
The list is very small, less than 300 records. We update the list several times a day without issue, adding, editing and deleting records from the list. 1 out of every 10 times it will crash. I have searched everywhere for resolution. I have tried 1) &quot;Use Cache format that is compatible with Microsoft Access 2010 and Later. 2) Online repair of office etc etc. Has anyone run into this?
</div>
</div>


Hello. Hoping someone can point me in the right direction. We recently began experimenting with Sharepoint List integration using Sharepoint Online and Office 365. Since integration with Access Desktop Apps was built in, we started there. I have a simple SharePoint list for tasking that was customized to add a few additional fields. Periodically, while using vba to update the Sharepoint List, it will cause Access to crash. The Event Log references an ntdll.dll error and sometimes an ACEWSS.DLL error. 

The list is very small, less than 300 records. We update the list several times a day without issue, adding, editing and deleting records from the list. 1 out of every 10 times it will crash. I have searched everywhere for resolution. I have tried 1) "Use Cache format that is compatible with Microsoft Access 2010 and Later. 2) Online repair of office etc etc. Has anyone run into this?

Updating Sharepoint lists from VBA crashes Access.

Microsoft Office is an integrated suite of applications that includes Outlook, Word, Excel, Access, PowerPoint, Visio and InfoPath, along with a number of tools to assist in making the individual components work together. Coding within and between the projects is done in Visual Basic for Applications, known as VBA.

Microsoft Office

Microsoft Sharepoint is a software platform and family of software products used for collaboration and web publishing combined. These capabilities include developing web sites, portals, intranets, content management systems, search engines, wikis, blogs, and other tools for business intelligence and collaboration. SharePoint has a Microsoft Office-like interface, and it is closely integrated with the Office suite.

Microsoft SharePoint

Office 365 is a group of software plus services subscriptions that provides productivity software and related services to its subscribers. Office 365 allows the use of Microsoft Office apps on Windows and OS X, provides storage space on Microsoft's cloud storage service OneDrive, and grants 60 Skype minutes per month. Office 365 includes e-mail and social networking services through hosted versions of Exchange Server, Skype for Business Server, SharePoint and Office Online, integration with Yammer, as well as access to the Office software. All of Office 365's components can be managed and configured through an online portal; users can be added manually, imported from a CSV file, or Office 365 can be set up for single sign-on with a local Active Directory using Active Directory Federation Services.

Microsoft 365

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.