{"id":271,"date":"2026-03-08T09:15:57","date_gmt":"2026-03-08T09:15:57","guid":{"rendered":"https:\/\/msaccesssolutions.com\/blog\/?p=271"},"modified":"2026-03-08T09:15:57","modified_gmt":"2026-03-08T09:15:57","slug":"microsoft-access-supports-large-number-data-type","status":"publish","type":"post","link":"https:\/\/msaccesssolutions.com\/blog\/ms-access\/microsoft-access-supports-large-number-data-type","title":{"rendered":"Microsoft Access Supports Large Number Data Type"},"content":{"rendered":"

[et_pb_section fb_built=”1″ _builder_version=”3.22″ background_color=”rgba(0,0,0,0.18)” background_image=”https:\/\/msaccesssolutions.com\/blog\/wp-content\/uploads\/2018\/08\/blog-head-bg.jpg” background_blend=”overlay”][et_pb_row _builder_version=”3.25″][et_pb_column type=”4_4″ _builder_version=”3.25″ custom_padding=”|||” custom_padding__hover=”|||”][et_pb_text _builder_version=”3.27.4″ header_text_color=”#ffffff” header_text_shadow_style=”preset1″]<\/p>\n

New For Microsoft Access 2016<\/h1>\n

[\/et_pb_text][\/et_pb_column][\/et_pb_row][\/et_pb_section][et_pb_section fb_built=”1″ custom_padding_last_edited=”on|desktop” _builder_version=”3.22″ custom_padding_tablet=”0px||0px||true” custom_padding_phone=”0px||0px||true”][et_pb_row column_structure=”1_3,2_3″ custom_padding_last_edited=”on|tablet” padding_top_bottom_link_1=”true” _builder_version=”3.25″ custom_margin=”0px||0px||true” custom_padding=”29px|0px|29px|0px|false|false” custom_padding_tablet=”0px||0px||true” custom_padding_phone=”0px||0px||true”][et_pb_column type=”1_3″ _builder_version=”3.25″ custom_padding=”0px||0px|” custom_padding_tablet=”0px||0px||true” custom_padding_phone=”0px||0px||true” custom_padding_last_edited=”on|tablet” custom_padding__hover=”|||”][et_pb_image src=”https:\/\/msaccesssolutions.com\/blog\/wp-content\/uploads\/2022\/07\/large-numbers-in-access-database-550×367.jpg” alt=”Microsoft Access support Big Numbers in its database program” title_text=”Big Numbers In Access” align_tablet=”center” align_phone=”” align_last_edited=”on|desktop” _builder_version=”4.7.7″][\/et_pb_image][\/et_pb_column][et_pb_column type=”2_3″ _builder_version=”3.25″ custom_padding=”|||” custom_padding__hover=”|||”][et_pb_text _builder_version=”3.27.4″ ul_font=”Trebuchet|700|||||||” ul_text_align=”left” ul_line_height=”1.5em” text_font_size_tablet=”” text_font_size_phone=”” text_font_size_last_edited=”on|tablet” ul_font_size_tablet=”” ul_font_size_phone=”13px” ul_font_size_last_edited=”on|phone” ul_letter_spacing_tablet=”” ul_letter_spacing_phone=”” ul_letter_spacing_last_edited=”on|phone” ul_line_height_tablet=”1.2em” ul_line_height_phone=”1.1em” ul_line_height_last_edited=”on|desktop”]<\/p>\n

New For Microsoft Access 2016
Support For Large Number (BigInt)<\/h2>\n

In March, 2017, the Microsoft Access Development Team announced new support for the Large Number data type in Microsoft Access. This additional feature came in response to a large number of requests listed in the Microsoft Access UserVoice forum. Many external data sources are imported or linked to Access utilize Big Int, therefore is very important for Access to include this feature.<\/p>\n

Much of the following information first appeared in an article in the Microsoft 365 Blog<\/a> March 6, 2017.<\/p>\n

[\/et_pb_text][\/et_pb_column][\/et_pb_row][et_pb_row _builder_version=”3.25″ custom_padding=”0|0px|0|0px|false|false”][et_pb_column type=”4_4″ _builder_version=”3.25″ custom_padding=”|||” custom_padding__hover=”|||”][et_pb_text ul_type=”square” ul_position=”inside” _builder_version=”3.27.4″ ul_font=”Trebuchet|800|||||||” ul_text_align=”left” ul_line_height=”1.5em” text_font_size_tablet=”” text_font_size_phone=”” text_font_size_last_edited=”on|tablet” ul_font_size_tablet=”13px” ul_font_size_phone=”” ul_font_size_last_edited=”on|tablet” ul_line_height_tablet=”1.2em” ul_line_height_phone=”1.1em” ul_line_height_last_edited=”on|tablet”]<\/p>\n

Developers Can Now Use Large Number Field<\/h3>\n

Large Number (BigInt), which is now a supported data type, provides additional analytical capability and deepens the integration experience when users are importing or linking to\/with BigInt data. When creating new local tables or editing existing ones, Access now allows users to add fields that store BigInt numbers.<\/p>\n

\"Microsoft<\/p>\n

Access Can Now Turn On\/Off Large Number For Linked Or Imported Tables<\/h3>\n

Customers specifically asked for the ability to import BigInt columns and link to tables with BigInt columns in a native way. We added an option for users to turn on\/off support for Large Number in the current database. 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.<\/p>\n

\"Microsoft<\/p>\n

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.<\/p>\n

Do we use BigInt (Large Number)? When it’s needed, yes we include the BigInt into our Access and SQL Server database applications. Do you know when and how to use BigInt? You don’t need to be an expert with this data field, that’s our business. Let the experts at MS Access Solutions do the analysis and development for your database project. Call us at (323) 285-0939<\/strong> to schedule a consultation to discuss your Microsoft database project.<\/p>\n

Microsoft Access Programmers Tucson AZ<\/h3>\n

MS Access Solutions is now providing Microsoft Access Programmer<\/a> services to all businesses in Tucson, Arizona and communities near Tucson, AZ.<\/p>\n<\/p>\n

[\/et_pb_text][\/et_pb_column][\/et_pb_row][\/et_pb_section]<\/p>\n","protected":false},"excerpt":{"rendered":"

[et_pb_section fb_built=”1″ _builder_version=”3.22″ background_color=”rgba(0,0,0,0.18)” background_image=”https:\/\/msaccesssolutions.com\/blog\/wp-content\/uploads\/2018\/08\/blog-head-bg.jpg” background_blend=”overlay”][et_pb_row _builder_version=”3.25″][et_pb_column type=”4_4″ _builder_version=”3.25″ custom_padding=”|||” custom_padding__hover=”|||”][et_pb_text _builder_version=”3.27.4″ header_text_color=”#ffffff” header_text_shadow_style=”preset1″] New For Microsoft Access 2016 [\/et_pb_text][\/et_pb_column][\/et_pb_row][\/et_pb_section][et_pb_section fb_built=”1″ custom_padding_last_edited=”on|desktop” _builder_version=”3.22″ custom_padding_tablet=”0px||0px||true” custom_padding_phone=”0px||0px||true”][et_pb_row column_structure=”1_3,2_3″ custom_padding_last_edited=”on|tablet” padding_top_bottom_link_1=”true” _builder_version=”3.25″ custom_margin=”0px||0px||true” custom_padding=”29px|0px|29px|0px|false|false” custom_padding_tablet=”0px||0px||true” custom_padding_phone=”0px||0px||true”][et_pb_column type=”1_3″ _builder_version=”3.25″ custom_padding=”0px||0px|” custom_padding_tablet=”0px||0px||true” custom_padding_phone=”0px||0px||true” custom_padding_last_edited=”on|tablet” custom_padding__hover=”|||”][et_pb_image src=”https:\/\/msaccesssolutions.com\/blog\/wp-content\/uploads\/2022\/07\/large-numbers-in-access-database-550×367.jpg” alt=”Microsoft Access support Big Numbers in its database program” title_text=”Big Numbers In Access” align_tablet=”center” […]<\/p>\n","protected":false},"author":4,"featured_media":1496,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_et_pb_use_builder":"on","_et_pb_old_content":"","_et_gb_content_width":"","cybocfi_hide_featured_image":"yes"},"categories":[4],"tags":[15,17,11,16,6,10],"acf":[],"_links":{"self":[{"href":"https:\/\/msaccesssolutions.com\/blog\/wp-json\/wp\/v2\/posts\/271"}],"collection":[{"href":"https:\/\/msaccesssolutions.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/msaccesssolutions.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/msaccesssolutions.com\/blog\/wp-json\/wp\/v2\/users\/4"}],"replies":[{"embeddable":true,"href":"https:\/\/msaccesssolutions.com\/blog\/wp-json\/wp\/v2\/comments?post=271"}],"version-history":[{"count":3,"href":"https:\/\/msaccesssolutions.com\/blog\/wp-json\/wp\/v2\/posts\/271\/revisions"}],"predecessor-version":[{"id":1498,"href":"https:\/\/msaccesssolutions.com\/blog\/wp-json\/wp\/v2\/posts\/271\/revisions\/1498"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/msaccesssolutions.com\/blog\/wp-json\/wp\/v2\/media\/1496"}],"wp:attachment":[{"href":"https:\/\/msaccesssolutions.com\/blog\/wp-json\/wp\/v2\/media?parent=271"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/msaccesssolutions.com\/blog\/wp-json\/wp\/v2\/categories?post=271"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/msaccesssolutions.com\/blog\/wp-json\/wp\/v2\/tags?post=271"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}