Hi Don. I was going to make the same suggestion as Jay. Dennis saved me many hours of work when I had a problem on my Legacy database a few years back. I also purchased L-Tools, but this was something Dennis showed me how to do apart from L-Tools because he knows Microsoft Access so well. I don't think he keeps up with the Legacy email lists, so if you want to see if he can help, I think you would have to email him directly at Dennis@zippersoftware,com
Jerry Boor - MerriamFamilyTree.org ------ Original Message ------ From: "Don Quigley" <[email protected]> To: [email protected] Sent: 3/2/2015 1:59:49 PM Subject: RE: [LegacyUG] View & Edit Legacy Data in MS Access >Yes, Jay, I have LTools. But it is limited in what I need to do and >(as you suggest) has issues with v.8 of Legacy. It has been a big help >to me, though, for figuring out what the various tables in the .fdb >file are for. > > > >Donald Quigley > >Escondido, CA > >Quigley Doyle Family Tree > >http://www.donquigley.net > > > >From: Jay Wilpolt [mailto:[email protected]] >Sent: Monday, March 02, 2015 10:43 AM >To:[email protected] >Subject: Re: [LegacyUG] View & Edit Legacy Data in MS Access > > > >Donald, > >Have you tried using LTools? > >It will make changes directly to the Legacy database. (needs to be >before Legacy 8) > >And it's written specifically as a tool for Legacy, whereas Access is >the format that Legacy database is stored in, the potential for an >error that could 'break' your Legacy database. > >The only time I have let Access make any changes is when my "File >Check" has completely hung up. (I mean like even after MANY hours) The >repair database tool seems to resolve the issue. > >Note: I am not connected in any way to the company that sells LTools, >just an EXTREME user of LTools , so much so that I have not migrated to >Legacy 8 because I still use LTools too much. > >The 'Data Bridge" tool is a magic wand that pulls all my tagged items >and bounces them against one of many Ancestry databases and allows drag >and drop and automated sourcing of records. > >Hope that helps, > >Jay > > > > > > >On Mon, Mar 2, 2015 at 9:26 AM, Don Quigley <[email protected]> wrote: > >Sorry if I’m asking a question that has been previously answered, but I >can’t seem to get into the old usergroup messages today. > > > >I have begun to use MS Access to check for errors, consistency and >missing information in my database sources. That works and I can >easily see what needs to be changed in Legacy. But a better approach >would seem to be to do the changes in the database tables directly in >Access – particularly where global search/replace and copy/paste tools >can be used. > > > >Does anyone know of a good “primer” for doing this with the Legacy >database? I’d like to avoid any pitfalls that others with more >experience have already identified. > > > >Donald Quigley > >Escondido, CA > >Quigley Doyle Family Tree > >http://www.donquigley.net > > > > > >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://support.legacyfamilytree.com >Follow Legacy on Facebook (http://www.facebook.com/LegacyFamilyTree) >and on our blog (http://news.LegacyFamilyTree.com). >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://support.legacyfamilytree.com >Follow Legacy on Facebook (http://www.facebook.com/LegacyFamilyTree) >and on our blog (http://news.LegacyFamilyTree.com). >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://support.legacyfamilytree.com >Follow Legacy on Facebook (http://www.facebook.com/LegacyFamilyTree) >and on our blog (http://news.LegacyFamilyTree.com). >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://support.legacyfamilytree.com Follow Legacy on Facebook (http://www.facebook.com/LegacyFamilyTree) and on our blog (http://news.LegacyFamilyTree.com). To unsubscribe: http://www.LegacyFamilyTree.com/LegacyLists.asp
