Re: [LegacyUG] Access Table

2009-08-12 Thread SgtBob
I do not have the original GEDCOM since this occurred some time ago. I think I will just wade through the 800+ Files, change the current filing and try to remember this incident when I next utilize a GEDCOM. Live and learn. Dennis - I realize that MRIN's do not have dashes in them, but this is

Re: [LegacyUG] Access Table

2009-08-11 Thread Heather Stovold
Sorry - I seemed to have deleted my answer while clearing out the extra stuff. If the Gedcom is still available - make a new file, import the gedcom, and don't renumber the MRIN's On Tue, Aug 11, 2009 at 10:56 PM, Heather Stovold wrote: > >>> >>> >> He imported from a gedcom, renumbering his MRI

Re: [LegacyUG] Access Table

2009-08-11 Thread Heather Stovold
> > >> >> > He imported from a gedcom, renumbering his MRIN's. He wants a way to > re-number them the way they were. > >

Re: [LegacyUG] Access Table

2009-08-11 Thread Gary Templeman
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" To: "Legacy" Sent: Tuesday, August 11, 2009 8:21 AM Subject: [LegacyUG] Access T

Re: [LegacyUG] Access Table

2009-08-11 Thread Gene Young
Dennis M. Kowallek wrote: On Wed, 12 Aug 2009 00:28:21 +0100, Jenny M Benson wrote: I think you might be! As I understand it, SgtBob uses the MRIN *with an appended hyphen and digit(s)* in the Filing Reference field.MRIN 1234, filing ref 1234-1 or 1234-2 etc. I think he confused the is

Re: [LegacyUG] Access Table

2009-08-11 Thread Dennis M . Kowallek
On Wed, 12 Aug 2009 00:28:21 +0100, Jenny M Benson wrote: >I think you might be! > >As I understand it, SgtBob uses the MRIN *with an appended hyphen and >digit(s)* in the Filing Reference field.MRIN 1234, filing ref 1234-1 >or 1234-2 etc. I think he confused the issue a little by referrin

Re: [LegacyUG] Access Table

2009-08-11 Thread Jenny M Benson
Dennis M. Kowallek wrote Maybe I'm the only one who doesn't have a clear understanding of where you are and where you want to go. I think you might be! As I understand it, SgtBob uses the MRIN *with an appended hyphen and digit(s)* in the Filing Reference field.MRIN 1234, filing ref 123

Re: [LegacyUG] Access Table

2009-08-11 Thread Dennis M . Kowallek
On Tue, 11 Aug 2009 17:58:01 -0400, SgtBob wrote: >Dennis - When I set up my paper source filing system to support my digital >files, I numbered master sources with 9000 series. i.e., 9212 might be >'Marriage License in Dead Center, Kansas'. Then I might assign 9030 as the >Master source for

Re: [LegacyUG] Access Table

2009-08-11 Thread SgtBob
Dennis - When I set up my paper source filing system to support my digital files, I numbered master sources with 9000 series. i.e., 9212 might be 'Marriage License in Dead Center, Kansas'. Then I might assign 9030 as the Master source for Joe and Susie who married in said location, but filed t

RE: [LegacyUG] Access Table

2009-08-11 Thread Valerie Laskowski
[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&

Re: [LegacyUG] Access Table

2009-08-11 Thread Jenny M Benson
SgtBob wrote 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 t

Re: [LegacyUG] Access Table

2009-08-11 Thread Dennis M . Kowallek
On Tue, 11 Aug 2009 11:21:16 -0400, SgtBob wrote: >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 cha

[LegacyUG] Access Table

2009-08-11 Thread SgtBob
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 ye