Thanks, Jerry. I have communicated with Dennis in the past.
Donald Quigley Escondido, CA Quigley Doyle Family Tree http://www.donquigley.net From: Jerry in Michigan [mailto:bearjerca...@gmail.com] Sent: Monday, March 02, 2015 12:43 PM To: legacyusergroup@LegacyUsers.com Subject: Re[2]: [LegacyUG] View & Edit Legacy Data in MS Access 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 <mailto:Dennis@zippersoftware,com> Dennis@zippersoftware,com Jerry Boor - MerriamFamilyTree.org ------ Original Message ------ From: "Don Quigley" < <mailto:dwquig...@cox.net> dwquig...@cox.net> To: <mailto:legacyusergroup@legacyusers.com> legacyusergroup@legacyusers.com 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/> http://www.donquigley.net From: Jay Wilpolt [mailto: <mailto:jaywilp...@aol.com> jaywilp...@aol.com] Sent: Monday, March 02, 2015 10:43 AM To: <mailto:legacyusergroup@LegacyUsers.com> legacyusergroup@LegacyUsers.com 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 < <mailto:dwquig...@cox.net> dwquig...@cox.net> 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/> http://www.donquigley.net Legacy User Group guidelines: <http://www.legacyfamilytree.com/Etiquette.asp> http://www.LegacyFamilyTree.com/Etiquette.asp Archived messages after Nov. 21 2009: <http://www.mail-archive.com/legacyusergroup@legacyusers.com/> http://www.mail-archive.com/legacyusergroup@legacyusers.com/ Archived messages from old mail server - before Nov. 21 2009: <http://www.mail-archive.com/legacyusergroup@legacyfamilytree.com/> http://www.mail-archive.com/legacyusergroup@legacyfamilytree.com/ Online technical support: <http://support.legacyfamilytree.com/> http://support.legacyfamilytree.com Follow Legacy on Facebook ( <http://www.facebook.com/LegacyFamilyTree> http://www.facebook.com/LegacyFamilyTree) and on our blog ( <http://news.legacyfamilytree.com/> http://news.LegacyFamilyTree.com). To unsubscribe: <http://www.legacyfamilytree.com/LegacyLists.asp> http://www.LegacyFamilyTree.com/LegacyLists.asp Legacy User Group guidelines: <http://www.legacyfamilytree.com/Etiquette.asp> http://www.LegacyFamilyTree.com/Etiquette.asp Archived messages after Nov. 21 2009: <http://www.mail-archive.com/legacyusergroup@legacyusers.com/> http://www.mail-archive.com/legacyusergroup@legacyusers.com/ Archived messages from old mail server - before Nov. 21 2009: <http://www.mail-archive.com/legacyusergroup@legacyfamilytree.com/> http://www.mail-archive.com/legacyusergroup@legacyfamilytree.com/ Online technical support: <http://support.legacyfamilytree.com/> http://support.legacyfamilytree.com Follow Legacy on Facebook ( <http://www.facebook.com/LegacyFamilyTree> http://www.facebook.com/LegacyFamilyTree) and on our blog ( <http://news.legacyfamilytree.com/> http://news.LegacyFamilyTree.com). To unsubscribe: <http://www.legacyfamilytree.com/LegacyLists.asp> http://www.LegacyFamilyTree.com/LegacyLists.asp Legacy User Group guidelines: <http://www.legacyfamilytree.com/Etiquette.asp> http://www.LegacyFamilyTree.com/Etiquette.asp Archived messages after Nov. 21 2009: <http://www.mail-archive.com/legacyusergroup@legacyusers.com/> http://www.mail-archive.com/legacyusergroup@legacyusers.com/ Archived messages from old mail server - before Nov. 21 2009: <http://www.mail-archive.com/legacyusergroup@legacyfamilytree.com/> http://www.mail-archive.com/legacyusergroup@legacyfamilytree.com/ Online technical support: <http://support.legacyfamilytree.com/> http://support.legacyfamilytree.com Follow Legacy on Facebook ( <http://www.facebook.com/LegacyFamilyTree> http://www.facebook.com/LegacyFamilyTree) and on our blog ( <http://news.legacyfamilytree.com/> http://news.LegacyFamilyTree.com). To unsubscribe: <http://www.legacyfamilytree.com/LegacyLists.asp> 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/legacyusergroup@legacyusers.com/ Archived messages from old mail server - before Nov. 21 2009: http://www.mail-archive.com/legacyusergroup@legacyfamilytree.com/ 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/legacyusergroup@legacyusers.com/ Archived messages from old mail server - before Nov. 21 2009: http://www.mail-archive.com/legacyusergroup@legacyfamilytree.com/ 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
