MS Access 2016 using SharePoint lists as tables – Access crash issue

This is due to how Access authenticates access to Sharepoint; the credentials are cached locally, and by user. Access is attempting to connect to these external lists, but has no credentials to do so.

This is an educated guess, but I think Access is looking for credentials in a location that doesn't have any for the current user; this is going to be a common issue for shared frontends with external tables in Sharepoint. Why it doesn't ask for credentials, I have no idea. That seems like the logical use case for when credentials don't exist.

To resolve this, I used a modified process from here:

1. Open Internet Options, either through Control Panel, or Internet Explorer. Note that Edge does not use these options, and changing settings for it will not affect this at all.
2. Add your Sharepoint site to your Trusted Sites.
3. Click Custom Level, and scroll all the way to the bottom. Choose, "Authenticate with current username and password".
4. Click OK, all the way back to Internet Explorer.
5. Navigate to your Sharepoint site.
6. When signing in, click, "Remember me".
7. (optional) After signing in, close Internet Explorer, and re-open it. Navigate back to your Sharepoint site and see if it remembered your credentials.
8. Open your Access database. It should now connect properly.