Using OPENDATASOURCE to insert mdb data into SQL Server
This is what worked for me:
Add full permissions to Everyone on C:\Users\SQL Service account name\AppData\Local\Temp

Here's the full thread:
https://stackoverflow.com/questions/26267224/the-ole-db-provider-microsoft-ace-oledb-12-0-for-linked-server-null