Mary, I have not used Paul's program as I do not have census events, but I am quite sure that he would not have anyone trying to mess with table IDs. I suggest you write to him off list and ask him to explain.
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/ ____________________________________________________ M. Brenzel wrote: > 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 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
