When working with a Microsoft Access database that is linked to SharePoint lists, you may encounter issues when trying to write to the database using Java, particularly with the UCanAccess library. The error messages you are seeing suggest that the linked SharePoint lists are causing the database to behave in a read-only manner.
Here are some potential solutions to address this issue:
Link to the SharePoint list directly to ensure all lookup tables are present in Access.
Delete the linked table for the SharePoint list.
Re-link to the SharePoint view using the ImportSharePointList macro action.
Going to File > Options > Current Database.
In the Caching Web Service area, select the "Never Cache" checkbox for Microsoft SharePoint tables.
Check Permissions: Ensure that you have the necessary permissions to write to the SharePoint lists. If your permissions are set to read-only, you will not be able to perform write operations.
Connection String: Verify that the connection string you are using in your Java application is correctly formatted and points to the right SharePoint list. Any errors in the connection string can lead to the warnings you are seeing.
Use the Latest Version of UCanAccess: Make sure you are using the latest version of the UCanAccess library, as updates may include bug fixes and improvements for working with SharePoint.
By addressing these areas, you should be able to resolve the issues you are facing when trying to write to an Access database linked to SharePoint lists.