GENBOX-L Archives

Archiver > GENBOX > 2004-03 > 1080251973


From: "wim prange" <>
Subject: RE: [GENBOX] Renumber Individuals and Sources?
Date: Thu, 25 Mar 2004 22:59:33 +0100
In-Reply-To: <CHEMKKAJHOKJPIEOPLKDGELEFBAA.clcasper@sprynet.com>


Hi CheriC,

just tested it on a test file again: last person in testfile had Ind# 867,
deleted an individual (Ind# 860) and after export the last person in file now
has Ind# 866. Have done the same with sources: deleted a couple of sources and
the highest source-ID# is the same as the amount of sourcerecords.

Tested it a second time with the option "linked only" checked for sources and
the results was the same: the sources were renumbered.

How did you export the file? I exported to a new genbox-database. Maybe
importing a genbox-database into a new file works differently?

Gr.




> -----Oorspronkelijk bericht-----
> Van: Cheri Casper [mailto:]
> Verzonden: donderdag 25 maart 2004 21:04
> Aan:
> Onderwerp: RE: [GENBOX] Renumber Individuals and Sources?
>
>
> Wim - I beg to differ. I have exported to a new file a couple of times and
> my sources still go from 171 to 328. Since I use the source number as a
> cross reference as well as the individual ID number, I certainly hope the
> gaps wouldn't be closed *unless the user specifically performed a
> renumbering action." That would make an abysmal mess of my paper system.
>
> CheriC
>
> -----Original Message-----
> From: wim prange [mailto:]
> Sent: Thursday, March 25, 2004 9:51 AM
> To:
> Subject: RE: [GENBOX] Renumber Individuals and Sources?
>
>
> Hi Karen,
>
> You can't renumber in Genbox and renumbering in Access is *not* a good idea:
> Genbox uses these numbers as pointers between the tables, you would create
> false links or links to non-existing records.
>
> To get rid of the gaps can be done with exporting the file to a new
> Genbox-database.
>
> Gr. Wim
>
> > -----Oorspronkelijk bericht-----
> > Van: Karen Carrigan [mailto:]
> > Verzonden: donderdag 25 maart 2004 18:34
> > Aan:
> > Onderwerp: [GENBOX] Renumber Individuals and Sources?
> >
> >
> > Hey Genbox List,
> > Has anyone tried to renumber either individuals or sources? Will opening
> > Genbox in MSAccess allow you to either change numbers or resequence? Not
> a
> > big deal...I just made a mess trying to combine 2 datasets, and have some
> > huge gaps in numbering after cleanup.
> > Karen
> >
> >
> > ==== GENBOX Mailing List ====
> > To join this list, send an email to
> > with the word "subscribe" as the subject line. Then email your
> > messages to and they will appear on this list.
> >
> > ==============================
> > Gain access to over two billion names including the new Immigration
> > Collection with an Ancestry.com free trial. Click to learn more.
> > http://www.ancestry.com/rd/redir.asp?targetid=4930&sourceid=1237
> >
>
>
> ==== GENBOX Mailing List ====
> To join this list, send an email to with the
> word "subscribe" as the subject line. Then email your messages to
> and they will appear on this list.
>
> ==============================
> Gain access to over two billion names including the new Immigration
> Collection with an Ancestry.com free trial. Click to learn more.
> http://www.ancestry.com/rd/redir.asp?targetid=4930&sourceid=1237
>
>
>
> ==== GENBOX Mailing List ====
> To join this list, send an email to
> with the word "subscribe" as the subject line. Then email your
> messages to and they will appear on this list.
>
> ==============================
> Gain access to over two billion names including the new Immigration
> Collection with an Ancestry.com free trial. Click to learn more.
> http://www.ancestry.com/rd/redir.asp?targetid=4930&sourceid=1237
>

This thread: