MS Access Autonumber dilemma

0

I am using a sql query that will copy the data from one table to another.

The problem though is the counter which I put in the Second table of my Insert into Select Statement.

It all started from the last count from the first table meaning the first table has 2000 as I insert it to second table the autonumber column of it started in 2000 not 1.

How should I reset it?

Lucas Juan

Posted 2013-12-23T07:00:39.237

Reputation: 69

It is likely there have been no comments or answers to this because you have not shown an effort to resolve this yourself. Below is my simple answer to get you headed in the right direction. – CharlieRB – 2013-12-23T13:43:39.970

Answers

0

There are many resources to research this topic. Searching the Internet for access reset autonumber, the first things that comes up is this Microsoft Support article - How to reset an AutoNumber field value in Access.

I've used this method successfully in the past. Remember...BACKUP, BACKUP, BACKUP!!

CharlieRB

Posted 2013-12-23T07:00:39.237

Reputation: 21 303

Asked: 2013-12-23T07:00:39.237

Viewed: 81 times

Active: 2013-12-23T13:44:04.047