The article explains in detail about the newly updated feature, Large Number Data Type Support.
The MS Access software keeps getting updating and Microsoft creates introduces new feature from time to time to address the issues faced by the users. After getting a lot of responses, Microsoft finally came up with the large number Support or BigInt support in their 2017 feature update.
On Access user Voice Forum, there were numerous requests regarding the issue of large number support. Best aspect of the feature is its linking and importing options that can read and write data from external data sources such as SQL. Now, the users of access can perform heavy, complex, analytical calculations with ease.
What does it do?
‘Large number’ is basically a data type that can now store a Non-monetary numeric value which earlier Versions of Access were unable to do. It is also compatible with SQL_BIGINT data-type in Open database connectivity. Now, it’s easier to work efficiently with calculations of extremely large numbers. It is an exciting update and was necessary too. It furthermore provides users the additional analytical features and eases the linking/importing process of BigInt data
It can be added as a field in the tables on MS Access and it can be linked with any of the databases with similar data type like SQL Server BigInt data-type. The update is for the higher versions of MS Access and it won’t work in lower versions.
How to use Large Number?
Number data type is only of four bytes while Access provides 8 bytes to The Large Number Data Type, thus giving it a greater range and scope for heavy mathematical calculations. You can use it by adding it as field to some Access table. Once you save the table design after adding it, it will display a warning box about compatibility with other versions.
Linking and Importing from outer sources
If you want to link to an external database, you have to select an option in Access Option Dialogue Box. Just Click File and select options and then select Current Database. Towards the bottom, you will find the section of Data-type Support Options. There you have to check/select the option of Support BigInt Data-type for Linked Tables. Once selected, the Large Number Data type will be enabled.
Access keeps the Large Number Data Type linking disabled by default.
Same procedure can be followed if you wish to perform import operation from external databases.
Impact of Large Number Data-type
It’s important to understand the impact it does on the database. When we enable the Large Number Data Type support, it’s for permanent use and it cannot be reversed. Also remember, this data type is not compatible with earlier versions of Access so be careful while choosing this option. Use it only when the record is of such higher mathematical value.
Users can open the databases of versions lower than 16.7 if the Large Number Data Type is not enabled. If it’s enabled then only users using database version 16.7 or higher can open it.
Incidents of database crash while working with MS Access may be a rare occurrence. However in case you ever encounter such a scenario, call in a powerful mdb repair at once.
Vivian Stevens is a data recovery expert in DataNumen, Inc., which is the world leader in data recovery technologies, including repair mdf and excel recovery software products. For more information visit www.datanumen.com