New in Access 2016—Large Number (BigInt) support
New data type support in Access which unlocks multiple scenarios based on Access’s ability to read and write data to and from external data sources that use BigInt (as PK or other), such as SQL.
When creating new local tables or editing existing ones, Access now allows users to add fields that store BigInt numbers.
We also added the option to turn on Large Number support for link to and import from external data sources. Turning Large Number support on allows users to import from and link to tables with BigInt columns, and have them represented in Access in a Large Number format.
Learn more here!