[MS_AccessPros] Primary Key Field to re-start numbering from 1

 

Hi

I have a table that is deleted and appended from time to time. The primary key has the following properties:

Field Name = ID

Data Type = AutoNumber

Field Size = Long Integer

New Values = Increment

Indexed = Yes (No Duplicates)

Text Align = General

Is there a way to get the ID to start at 1 when the table is cleared (deleted) and appended every time?

Thanks

James

__._,_.___

---

Posted by: James Asante <asanteza@gmail.com>

---

Reply via web post

•

Reply to sender

•

Reply to group

•

Start a New Topic

•

Messages in this topic (1)

Visit Your Group

• New Members 4

• Privacy • Unsubscribe • Terms of Use

.

__,_._,___