Windows Store Watch

Windows ストアを見守るブログ

【更新】Access 2016(デスクトップ:Windows)

March 2017 Updates *

(Only available to Insiders at this time.)

Large Number (bigint) support

Support for Large Number data types was highly requested by our customers. You asked for it on our Access User Voice forum.
The Large Number data type stores a non-monetary, numeric value and is compatible with the SQL_BIGINT data type in ODBC. This data type efficiently calculates large numbers.
You can add Large Number as a field to an Access table. You can also link to or import from databases with a corresponding data type, such as the SQL Server bigint data type. To add the Large Number data type, you need Access 2016 (16.0.7812 or higher build)

f:id:daruyanagi:20170329112606p:plain

To use the Large Number data type for support in linking to or importing from external sources, you'll first need to select an option in the Access Options dialog box. ClickFile >Options >Current Database. At the bottom of the options dialog you'll see theData Type Support Options section. Select theSupport BigInt Data Type for Linked/Imported Tables option.

f:id:daruyanagi:20170329112623p:plain

For more information about using Large Number in your Access databases, see Using the Large Number data type.