Microsoft SQL Server ResourcesUpsizing Microsoft Access to SQL Server Tip for AutoNumber Data Types with Increment or Random Settings

Microsoft Access AutoNumber Field Type

In Microsoft Access, AutoNumber fields are long integer data types that are automatically filled with a unique value when a new record is added to the table. There are two types of AutoNumber values that can be created by setting the NewValues property to Increment or Random:

Setting Description
Increment (Default) AutoNumber field values increment by 1 for new records.
Random AutoNumber field values are assigned a random Long Integer value for new records.

When the tables are upsized to Microsoft SQL Server, it is important to note the property settings that are created during the process. The most important one is how the identity values are generated.

NewValue Setting in MS Access Property Setting in Microsoft SQL Server Identity Values
Increment Default Value = (disabled)
Identity = YES
Identity Seed = 1
Identity Increment = 1
Values are incremented by the property settings
Random Default Value = 0
Identity = NO
Identity Seed = (disabled)
Identity Increment = (disabled)
A trigger is created automatically to manage the random values assigned to the field when a new record is added to the table

Strategic Overview

SQL Server Express

SQL Azure Cloud

What it Means to Information Workers

Link Microsoft Access to SQL Azure Databases

Deploy MS Access DBs linked to SQL Azure

Eliminate SQL Azure Security Holes

Monitor SQL Server Usage and DTU Limits on Azure

Convet Azure SQL Server to Elastic Pools

SQL Server Tips

Database Users and Permissions

Database Backup and Restore on Network

AM/PM Date Time Format

Get Date Portion

Set NOCOUNT ON

Running Total

Videos

Migrate Your Data Tier to SQL Server: Strategies for Survival

Microsoft Access Database and Migration Challenges

Are we there yet? Successfully navigating the bumpy road from Access to SQL Server

Visual Studio LightSwitch

LightSwitch Introduction

Comparison Matrix

Services

Microsoft SQL Server Consulting Services

Visual Studio .NET programmers for web development

General Microsoft Access consulting services

Additional Resources

Microsoft Access Help

Microsoft Access Developer Help Center

MS Access Developer Programming

More Access and SQL Tips

Technical Papers

Microsoft Access Tools

Connect with Us

 

Free Product Catalog from FMS