|
| |
|
|
xterradane
Posts: 143
From: Mobile, AL USA
Status: offline
 |
Autonumber Reset - 8/23/2002 13:08:25
I know I have seen this on here about two years ago, but can' t find it now. I am wanting to send someone a database that I created. They don' t need the data just the format, so I wanted to delete all records. However, there are two autonumber fields that it would be nice if it could start at zero/one instead of the number where I left off.
I tried the Append Table to reset it, but that didn' t work like I thought it would. Any pointers?
Thanks,
Gail
|
|
|
|
Long Island Lune
Posts: 2339
Joined: 6/8/2002
From: New York
Status: offline
|
RE: Autonumber Reset - 8/23/2002 13:24:37
I had this problem too a long time ago. From what I know about MS-Access, they do not let you change the Autonumber value. I searched an MS-Access book and on-line help till I was blue in the face. I found some help that stated you cannot change the autonumber field. That' s all. If there is a way to do this, I' m all ears too.
_____________________________
| |
|
|
|
daveh42
Posts: 83
From: Maine USA
Status: offline
|
RE: Autonumber Reset - 8/23/2002 14:02:51
I think if you delete all the records in the tables and then compact the database the autonumber fields should be reset.
| |
|
|
|
Doug G
Posts: 1197
Joined: 12/29/2001
From: SoCal
Status: offline
|
RE: Autonumber Reset - 8/23/2002 15:38:55
If you need to reset only one table (empty) you can copy the structure to a new table, delete the old table and rename the new to the old. This also resets the autonumber for the table back to 0.
_____________________________
======
Doug G
======
| |
|
 New Messages |
 No New Messages |
 Hot Topic w/ New Messages |
 Hot Topic w/o New Messages |
 Locked w/ New Messages |
 Locked w/o New Messages |
|
Post New Thread
Reply to Message
Post New Poll
Submit Vote
Delete My Own Post
Delete My Own Thread
Rate Posts
|
|
|
Printable Version 
