A new data type was introduced last year in Microsoft Access, i.e. Large Number (BigInt).
The Large Number data type can handle bigger numbers than the standard Number data type, i.e. 8 bytes vs 4 bytes. While the Number data type has a range of -231 to 231-1, the Large Number type has a range of -263 to 263-1.
Here's an article from Microsoft on using the new Large Number data type. It lists a few things to note about using it:
- By default, Large Number is not enabled for linking and importing operations.
- Existing tables are not automatically converted.
- Enabling support of the Large Number data type is a permanent change to the database that cannot be reversed, and earlier versions than the updated version of Microsoft Access 2016 (i.e. lower than version 16.0.7812) will not have Large Number enabled so will not be able to open that database file.
Be sure to read the article on using the new Large Number data type before you start using the new Large Number data type to understand the consequences, particularly on backward compatibility.
Here's what Microsoft has to say on who has access to the new Large Number feature.
QUOTE:
Currently, support for Large Number in Access 2016 is available to Office 365 subscribers. This feature will first roll out to Office Insider participants and later to consumer and commercial Office 365 subscribers. If you have an Office 365 subscription, make sure you have the latest version of Office.