Restart auto number after deleting records

If I delete a record using a query, is there a way to restart auto number to start at 1 and increase in consecutive integers, or is that just going to cause issues with the data?

The autonumber is my primary key and doesn't really have anything to do with the other data in the table (i.e. I don't care if the auto number changes on a record, provided the other data doesn't change).

Sponsored Links:

Related Topics

Restart auto number after deleting records
If I delete a record using a query, is there a way to restart auto number to start at 1 and increase in consecutive integers, or is that just going to cause issues with the data?

The autonumber is my primary key and doesn't really have anything to do with the other data in the table (I.e. I don't care if the auto number changes on a record,


Appending Records with a desired auto number in a table with Auto Number
Here is my issue. In a table with an Auto Number index some records have been deleted. I have been able to recreate them along with their original auto number. The problem is that I do not know how to append these records forcing the original auto number. I have tried changing the auto number field to a number field in the table, this works except I cannot change it back to auto number.

I am sure Im not the first with this question or issue. I did search through a couple hundred entries about auto number before I posted this question


Combobox inserts new records to my querry
I built up a subform in a form which contains a combobox (ranking) to choose different records (good [auto-number 1], bad [auto-number 2], unknown [auto-number 3]).
In the property sheet I chose Limit To List "Yes".
I can only add the words good, bad or unknown, which was my goal. But access creates new records into my querry. When I chose unknown it saves unknown [auto-number 4]. So the next time I can choose between good [auto-number 1], bad [auto-number 2], unknown [auto-number 3] and unknown [auto-number 4].
Therefore I save the information but I cannot use it in the end because every record has a different auto-number.
Can someone please help me, I already spend 6h try and research on the internet but I could not find an answer


Question about auto numbering
I have an access database that's published to sharePoint services. The database contains one table. We used Microsoft's 'Assets Database' Template to initially set it up. I've changed quite a bit around in the template to make it fit our needs, and things seem to be coming along just fine for the most part.

We used auto numbering for each record, the auto number is the first field in the database ( I believe this is my primary key as well). when a user deletes a record - say record 4 for example - the database does not renumber the records it just shows the records in order as 1, 2, 3, , 5, 6, etc. skipping number 4. So this puts my users in a position where they have no idea how many actual records are in the database.

Is there a way to have access re-number the records? I assumed when I setup auto numbering for column 1 that it would do this.


Auto fill data (number) between tables
I created a database to track a group of records (people). I couldn't figure out how to auto number the primary key to a random unique number that was less than 10 digits so I generated a list of random numbers and just use the next number off the list as I enter the next person which works OK- but I have to put that number on each table as the ID number to relate back to the Primary key and it seems that I should be able to have those auto fill with the entered number. Is it possible to have the number typed in "table 1" (people) primary key auto fill onto each of the other tables as an ID number?


Can I Re-set an auto number field ?
Have copied one of my databases, re-named it and deleted all records. I want it for another purpose but in terms of fields, design and reports it is just what I need.

However - I have an auto field - record number - this obviously remains at the number of the last record in the (deleted) database.

Can I re-set the numerical origin of this field to start again at one ? Or do I have to delete it and set up another auto record number field ?

This is not an urgent enquiry - probably a bit basic for many on the forum - but just to add to my knowledge of Access.


Deleting duplicate records
I have a table: [Related Submissions]
Fields: Autonumber (Primary key), [SUbmission Number 1], [Submission Number 2], Relationship
Using Access 2002

I want to remove duplicate records where for two records, [Submission number 1], Submission Number 2] and Relationship are the same. It is easy to find the duplicates, but is there any wayto remove one of the duplicate records?


Deleting records from multiple tables
I am deleting records from multipletables but it doesn't work for me. [SQL CODE]:


Identity specification in sql server
I am new to sql server.I have a table with id as auto field.so I have records from 1,2.100.Now I am deleting last 10 records 90 to 100. So now I have 90 records.

Next time if I enter a record I want the is to be 91.but its as 101.


Auto Number in Access Query
I need to have an auto number in an access query, this is not the auto number already existing in the table. I need a separate auto number field in the query which begins with 1 and is in increasing order.


Adding a single record to another table with auto number
Here's my case: I have to issue a document that has 2 auto numbers: One upon creation of the file and the other upon printing.

My initial idea was to create 2 tables, the first contains the "creation" auto number, when I'm ready to print I use an append query to send it to the second table and the second auto number will be assigned automatically.

The thing is that the "creation" auto number and the "printing" auto number won't be at the same order, for example: I might have 3 files, but might print file Number 3 before number 2 and so on and so forth.

Query Append and query update won't work and will give me errors


Auto generate reference number
I have a question about the auto-generate number feature in access tables.

I want to paste records that have unique reference numbers from an excel sheet into my access data table.

However when I do this Access changes the reference numbers as the relevant column in the table automatically generates a number series.

Is there any way of turning off this auto generate feature?


Auto generate reference number
I have a question about the auto-generate number feature in access tables.

I want to paste records that have unique reference numbers from an excel sheet into my access data table.

However when I do this Access changes the reference numbers as the relevant column in the table automatically generates a number series.

Is there any way of turning off this auto generate feature


Is there a way to specify a value when using an auto-increment field
I need to add items from one table to another preserving each records id which is an auto-incrementing field. However, access won't let me modify the id field for a record. I can change the table to make the field a normal number field so I can import the records. However, I can't make the field auto-increment again if there's any records in the table. I need to modify an auto-incrementing field


Auto number
Can I make the start auto number from a value that I choose? like the auto number starts from 95?


Access auto numbers
I have just started using access 2007. I used 2000 in the past. I need help with handling auto numbers. In my 2000 data base I had a Serial Number field that I had populated by auto number seeded from a table with a number starting at 1000. I'm having a problem reconstructing a similar database using auto number in that field. I can change the format to get the 4 digit number, but when I run a query to find a certain serial number, I can't find it unless I enter just the last 3 digits. How can I create a serial number field starting at 1000 in stead of 1?

It would to build the serial number using the format of the last 2 digits of the year and a 4 digit number, like 09-1001.


Deleting Records using VBA Module
What is the recommended method for deleting records using a VBA module? Currently I am using an SQL method that specifies the table name and the upper time stamp date from which values should be deleted.

My database is continually being updated with new files from this same VBA module. I would like to delete old records based on a rolling window (say 30 days). Would this be the best way to go? It seems a bit slow.but then again my database contains 1 million + records.


Generating an auto-number in a report?
First off, can it be done? I'm using Microsoft Access 2007, I'm wanting to generate an auto-number on the report. Basically I have an OrderTable, a PartTable, and a PackingListTable. I have a report that shows all orders ready to be shipped.

But I need the shipping report to have a packing list number. I want this number to be auto-generated,

Right now the report is generated through a query of orders that are ready to be shipped. Yet I can't figure out how to put an auto-generated packing number on thereport.


Locked Access Database
I have an Access database with a number of users connecting to it from within Citrix. Occasionally, the database locks up and you can only open it in a "read only" mode. I tried deleting the .laccdb file to unlock it.

But so far the only way to delete it is by restarting the Citrix server. I can only get our tech guys to restart the server at night. We lose a whole day of work when it happens.


Auto Numbering 2 fields in an append query
I would like to import excel data and append it to an existing DB. In the past all data has been entered from the keyboard. Now a lot of what I get is in a form I can convert to an excel spreadsheet.

The difficulty I have is that there are 2 tables involved. One creates a auto batch number for a group of entries the other an auto number for each of the group entries. There is of course common data between the two tables and the link is an operator number.

Searching the lounge and the web the best I can work out is not to include the auto number fields in theappend query is there anything else I should know or do.