How long ago did your initial error take place? If all you have done since
is upload (I think you mean import) some GEDCOMs, by far the easiest way to
fix the issue is to restore your data using the backup you made just prior
to the initial screw up. That will get you back to all the original numbers.
Then redo your imports using the correct parameters. With a proper backup
you don't need to fuss with Access at all.
Gary Templeman
----- Original Message -----
From: "SgtBob" <s...@cox.net>
To: "Legacy" <LegacyUserGroup@legacyfamilytree.com>
Sent: Tuesday, August 11, 2009 8:21 AM
Subject: [LegacyUG] Access Table
I have encountered a colossal problem that was brought about by an action I
must have inadvertently taken (shame on me) to allow a re-numbering of one
or more fields - specifically the MRIN numbers. Evidently I wasn't paying
attention on a GEDCOM upload feature and didn't discover this until
yesterday - after several of these uploads occurred to my dismay.
My problem - I use the 'MRIN+number' feature to file paper documents and
also enter this number in the detail 'FileID' box in Legacy. I'm in the
process of renumbering these hundreds of documents due to the above
situation - a most laborious project!!!
My Hope - Is there any table, when viewing a 'Bob1.fdb' (I have a
multitude of backups thank goodness), in Access that would permit me to
enter/alter the File ID? I have looked at my 'tblSX' and observe that
there are a number of items that look like my MRIN+number data under the
column entitled 'Filing Ref' . This appears to be a possible opportunity
to correct my errors. Is it possible that changing/correcting/entering
the current File Id number (noted as my MRIN+number) in this column might
accomplish my goal? If not, please suggest a solution.
Legacy User Group guidelines:
http://www.LegacyFamilyTree.com/Etiquette.asp
Archived messages:
http://www.mail-archive.com/legacyusergroup@legacyfamilytree.com/
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:
http://www.mail-archive.com/legacyusergroup@legacyfamilytree.com/
Online technical support: http://www.LegacyFamilyTree.com/Help.asp
To unsubscribe: http://www.LegacyFamilyTree.com/LegacyLists.asp