Autonumber not unique - Microsoft Access / VBA

Tyler

I have a table where some of the entries have been deleted so the
primary key field which is set as an autonumber field is not
contiguous. When I try to ad a new record it starts numbering lower
than my highest number.

For example:
1
2
5
7

when I add a new record it tries to make the autonumber 5 then errors
out. I am sure this is an easy solution but I am racking my brain!
Thanks in advance.

Jul 24 '08 #1

Subscribe Post Reply

1772

Allen Browne

See:
Fixing AutoNumbers when Access assigns negatives or duplicates
at:
http://allenbrowne.com/ser-40.html

The article explains what triggers this bug, and the code resets the
AutoNumber for any tables that currently have the Seed too low.

--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Tyler" <ty***********@gmail.comwrote in message
news:5e**********************************@t54g2000 hsg.googlegroups.com...

>I have a table where some of the entries have been deleted so the
primary key field which is set as an autonumber field is not
contiguous. When I try to ad a new record it starts numbering lower
than my highest number.

For example:
1
2
5
7

when I add a new record it tries to make the autonumber 5 then errors
out. I am sure this is an easy solution but I am racking my brain!
Thanks in advance.

Jul 24 '08 #2

Tyler

On Jul 24, 8:17*am, "Allen Browne" <AllenBro...@SeeSig.Invalidwrote:

See:
* * Fixing AutoNumbers when Access assigns negatives or duplicates
at:
* *http://allenbrowne.com/ser-40.html

The article explains what triggers this bug, and the code resets the
AutoNumber for any tables that currently have the Seed too low.

--
Allen Browne - Microsoft MVP. *Perth, Western Australia
Tips for Access users -http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Tyler" <tyler.horn...@gmail.comwrote in message

news:5e**********************************@t54g2000 hsg.googlegroups.com...

I have a table where some of the entries have been deleted so the
primary key field which is set as an autonumber field is not
contiguous. *When I try to ad a new record it starts numbering lower
than my highest number.

For example:
1
2
5
7

when I add a new record it tries to make the autonumber 5 then errors
out. *I am sure this is an easy solution but I am racking my brain!
Thanks in advance.- Hide quoted text -

- Show quoted text -

AWESOME thanks.

Jul 24 '08 #3

Similar topics

Autonumber code

by: Tony Williams | last post by:

I have a table called tblseries with a field NextNumber I also have a form called form1 based on table1 On the form is a control NNum which I've called NNumtxt with the following code in the...

Microsoft Access / VBA

AutoNumber Sequence Change in Same Table

by: Charles Robinson III | last post by:

The AutoNumber sequence in my database is currently formatted as '000000'. When a new record is created, the AutoNumber would go from 000001, 000002, 000003 and so on. I want to track via...

Microsoft Access / VBA

Table w/ Autonumber AND Cascade update

by: Lee C. | last post by:

I'm finding this to be extremely difficult to set up. I understand that Access won't manage the primary key and the cascade updates for a table. Fine. I tried changing the PK type to number and...

Microsoft Access / VBA

Restart Autonumber

by: Traci | last post by:

If I have a table with an autonumber primary key and 100 records and I delete the last 50 records, the next record added would have a primary key of 101. Is there any way to have the primary key...

Microsoft Access / VBA

Will "Random AutoNumber" reuse deleted values?

by: yf | last post by:

A KB article "http://support.microsoft.com/default.aspx?scid=kb;en-us;209599" tells that the maximum number of records that a table may hold if the PRIMARY key data type is set to AUTONUMBER is...

Microsoft Access / VBA

Am I Screwed with Autonumber?????

by: mathilda | last post by:

I have a situation where I need to put back in a deleted record to a table whose primary key is an Autonumber. And of course the autonumber has to match what it was before. Any way of saving my...

Microsoft Access / VBA

Accessing Access mdb via ODBC - how to return autonumber

by: Steven Taylor | last post by:

Hope someone can help. This is half an Access question. The half I'm using is Access Xp as a backend data file. I'm using ODBC to connect to the data file. All commands are via SQL type...

Microsoft Access / VBA

VB6 app may need to generate its own ACCESS AUTONUMBER VALUES???

by: Alan Mailer | last post by:

A project I'm working on is going to use VB6 as a front end. The back end is going to be pre-existing MS Access 2002 database tables which already have records in them *but do not have any...

Microsoft Access / VBA

Duplicate numbers in "Autonumber" field -- help!

by: Tom_F | last post by:

To comp.databases.ms-access -- I just discovered, to my more than mild dismay, that some tables in my Microsoft Access 2003 database have duplicate numbers in the "AutoNumber" field. (Field...

Microsoft Access / VBA

AutoNumber jumps numbering

by: Gogo | last post by:

Database has record 59 showing, tabing to enter data returns autonumber to 134. What happened to cause this, how would I fix it?

Microsoft Access / VBA

How to turn on java script in a villaon keypad mobile phone

by: Charles Arthur | last post by:

How do i turn on java script on a villaon, callus and itel keypad mobile phone

Java

Merging data from multiple Excel files

by: ryjfgjl | last post by:

In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...

Data Management

Migrating Website to Cloud - Emmanuel Katto

by: emmanuelkatto | last post by:

Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel

General

Is that possible of reading the .csv file in column wise and the column have different lengths ?

by: Sonnysonu | last post by:

This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...

C / C++

How to build RAID in BIOS?

by: Hystou | last post by:

There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...

Computer Hardware

What is ONU?

by: marktang | last post by:

ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...

General

Problem With Comparison Operator <=> in G++

by: Oralloy | last post by:

Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...

C / C++

Maximizing Business Potential: The Nexus of Website Design and Digital Marketing

by: jinu1996 | last post by:

In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...

Online Marketing

The easy way to turn off automatic updates for Windows 10/11

by: Hystou | last post by:

Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...

Windows Server