In response to one of the most requested items on the Microsoft UserVoice forum, the Microsoft Access team is pleased to announce support for a new data type in Access 2016—Large Number (BigInt).
A significant aspect of business solutions built on Access is the ability to read and write data to and from external data sources that use BigInt (as PK or other), such as SQL.
Add Large Number field to local tables
Large Number (BigInt)—now a supported data type—provides additional analytical capability and deepens the integration experience when users are importing/linking BigInt data. When creating new local tables or editing existing ones, Access now allows users to add fields that store BigInt numbers.