 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / New Users / July 2006Clear Database and Reset the AutoNumber
Good Morning Everyone, I'm making a database and I'm playing with it using test data. When I want to put the actual data in, how do I reset the autonumber back to 1? How do I tell the database to completely delete the fake records so the autonumber doesn't start at, o, 50? Thanks! Jillian This post was responded to on the FormsCoding group... Al Camp > Good Morning Everyone, > [quoted text clipped - 5 lines] > Thanks! > Jillian It wasn't until I reposted it the fourth time that I thought doing so was a bad idea! I didn't think it would be that annoying since they were different newsgroups, but at least I know now. Thanks to everyone who helped me! Jill Also, thanks for that suggestion. No big deal at all Jilian... As Fred says, if you put both group names in the Newsgroup line, then any posts in response (in either group) show up in both. Then, folks helping out, can see the full sequence of the problem and responses. Good luck with your Access, Al Camp > Also, thanks for that suggestion. > Good Morning Everyone, > [quoted text clipped - 5 lines] > Thanks! > Jillian Answered elsewhere. Please do not multi-post. If you feel you must post the same question to more than one newsgroup (and it's seldom necessary), cross-post by adding each additional newsgroup in the To Newsgroups: box, separated by a comma. This way an answer in one newsgroup will be seen in each of the others. More readers will see the response and learn, and less time will be spent on duplicate answers. See Netiquette at http://www.mvps.org/access It's a great site to visit anyway.  SignatureFred Please respond only to this newsgroup. I do not reply to personal e-mail |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.