Since Access 2010 they’ve replaced Jet with ACE (Access Database Engine), which added some needed changes like 64-bit support. I do agree it works well as a file-based (no server) database engine, but a file-based data engine is always going to have certain limitations, sadly.