I am using EntityFramework.Jet for MS Access which is written by a Non-Microsoft third party listed on Github. This is not the Microsoft OLE DB Drivers now present in MSAccess or native in VisualStudio.
The link is below. Perhaps I am missing part of their stack... https://github.com/CirrusRedOrg/EntityFrameworkCore.Jet
This repo said to use this tag. and BTW I have tried to run this query with and without the attach function to no avail. I am okay with writing it in another way, but just having no luck with Inserts, or Updates on this EntityFramework driverset.