If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Table autonumbers - possible reset?
Can anyone suggest a possible solution. I am developing
an MS Access Application and in the course of development I'm entering dummy data to verify functionality. At the end of the development cycle I would like to wipe the contents of the db and have all the autonumber fields reset themselves so that when new entries are made the real data that is being entered has autonumber entries that begin again at 1. Can anyone suggest a good way of being able to achieve this? Thanks Bob |
#2
|
|||
|
|||
after deleting the "dummy" records in the table(s), compact your database.
"Bob" wrote in message ... Can anyone suggest a possible solution. I am developing an MS Access Application and in the course of development I'm entering dummy data to verify functionality. At the end of the development cycle I would like to wipe the contents of the db and have all the autonumber fields reset themselves so that when new entries are made the real data that is being entered has autonumber entries that begin again at 1. Can anyone suggest a good way of being able to achieve this? Thanks Bob |
#3
|
|||
|
|||
Bob wrote:
Can anyone suggest a possible solution. I am developing an MS Access Application and in the course of development I'm entering dummy data to verify functionality. At the end of the development cycle I would like to wipe the contents of the db and have all the autonumber fields reset themselves so that when new entries are made the real data that is being entered has autonumber entries that begin again at 1. Can anyone suggest a good way of being able to achieve this? Thanks Bob Tina suggested a way to reset the numbers. I suggest you may not want to use Autonumber for that use. Autonumbers are designed to provide unique numbers. It in not designed to provide numbers in order and for a number of reasons may not do so. As a result using them in any application where the user sees the numbers is likely to end up with confusion. There are other ways of providing the numbers you want depending on the particular application. -- Joseph E. Meehan 26 + 6 = 1 It's Irish Math |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
"automatically resize to fit contents" grayed out | T | Tables | 5 | July 26th, 2004 12:44 PM |
Complicated Databse w/many relationships | Søren | Database Design | 7 | July 13th, 2004 05:41 AM |
Newbie? Do I use Report or Query | John Egan | New Users | 11 | June 28th, 2004 08:31 PM |
Image Control Table | John Gavin | General Discussion | 3 | June 28th, 2004 04:21 AM |
resize table from A4 size to A5 | ims | New Users | 3 | June 9th, 2004 01:05 AM |