Because I wanted to use Paul's Census Finder program which currently uses ID = 12 for Census Event. I deleted quite a few of the events provided with Legacy, including the Census event. I have found a workaround using a copy of my database and updating the IDET in tblER for those census records.
Mary -----Original Message----- From: Ron Ferguson [mailto:[email protected]] Sent: Saturday, January 02, 2010 5:02 AM To: [email protected] Subject: Re: [LegacyUG] Reset Autonumber M. Brenzel wrote: > This is an Access question as I am trying to manipulate my Legacy > database using Access. Yes, I am working with a backup copy of my > database. > > Is there a way to reset the value to be used as the next ID in a > table? The field type is AutoNumber. I know that I can't change the > value of the ID in a table. I would like to force a new record to > use the ID (autonumber) of one that no longer exists in the table. > > I know Access quite well but I haven't been able to find this out. > I'm hoping that Access doesn't look at the highest number and add one > to it for the next new record. > > Thanks much! > > Mary Mary, It is not possible to do what you are requesting as this is a Primary Field and is used with the SQL to link fields together. If you did you would end in a disaster. What is more puzzling is why you should wish to do this as they are not relevant to anything which you can change in Legacy. Ron Ferguson _____________________________________________________ Create your Website with Legacy, see Tutorials at: http://www.fergys.co.uk Includes the family tree for Alan J Grimshaw http://www.fergys.co.uk/Grimshaw/ For The Fergusons of N.W. England http://myweb.tiscali.co.uk/fergys/ ____________________________________________________ Legacy User Group guidelines: http://www.LegacyFamilyTree.com/Etiquette.asp Archived messages after Nov. 21 2009: http://www.mail-archive.com/[email protected]/ Archived messages from old mail server - before Nov. 21 2009: http://www.mail-archive.com/[email protected]/ Online technical support: http://www.LegacyFamilyTree.com/Help.asp To unsubscribe: http://www.LegacyFamilyTree.com/LegacyLists.asp Legacy User Group guidelines: http://www.LegacyFamilyTree.com/Etiquette.asp Archived messages after Nov. 21 2009: http://www.mail-archive.com/[email protected]/ Archived messages from old mail server - before Nov. 21 2009: http://www.mail-archive.com/[email protected]/ Online technical support: http://www.LegacyFamilyTree.com/Help.asp To unsubscribe: http://www.LegacyFamilyTree.com/LegacyLists.asp
