Hi.. after I create a tables, query, reports and forms, I make the test on my database how can I delete all the data during my test and return the auto number key to start from 1? Thank you for the videos they are basic and helpful.
In SQL Server you can reset the starting autonumber to 1 -- it's called "re-seeding the identity." So for those who has an SQL Server back end and has linked tables in Access, it's possible. You just run a simple stored procedure on SQL Server like this:
DBCC CHECKIDENT ('[MyTable]', RESEED, 0);
This will make the starting value 1 again. Of course, if 1, 2, 3, etc. are already used, resetting it to 1 will cause duplicate primary key error.
If you are a Visitor, go ahead and post your reply as a
new comment, and we'll move it here for you
once it's approved. Be sure to use the same name and email address.
This thread is now CLOSED. If you wish to comment, start a NEW discussion in
Visitor Forum.
