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:jaywilp...@aol.com] Sent: Monday, March 02, 2015 10:43 AM To: 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 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/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 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
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 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/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
RE: [LegacyUG] View & Edit Legacy Data in MS Access
Right! So far I've only been opening a copy of the .fdb file. Donald Quigley Escondido, CA Quigley Doyle Family Tree http://www.donquigley.net -Original Message- From: Sherry/Support [mailto:she...@legacyfamilytree.com] Sent: Monday, March 02, 2015 9:36 AM To: legacyusergroup@LegacyUsers.com Subject: Re: [LegacyUG] View & Edit Legacy Data in MS Access ALWAYS Back up the file (File > Backup File) before even *looking* at the tables in Access - for fear of inadvertent change. Sincerely, Sherry Technical Support Legacy Family Tree On Mon, Mar 2, 2015 at 9:26 AM, Don Quigley 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 > 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
RE: [LegacyUG] View & Edit Legacy Data in MS Access
They are within the .fdb file created by legacy. Donald Quigley Escondido, CA Quigley Doyle Family Tree http://www.donquigley.net From: Graham Love [mailto:love-fam...@blueyonder.co.uk] Sent: Monday, March 02, 2015 9:30 AM To: legacyusergroup@LegacyUsers.com Subject: RE: [LegacyUG] View & Edit Legacy Data in MS Access I've been meaning to do the same but I can't find any of the tables. Do you know where they are? Graham From: Don Quigley [mailto:dwquig...@cox.net] Sent: 02 March 2015 17:27 To: legacyusergroup@LegacyUsers.com Subject: [LegacyUG] View & Edit Legacy Data in MS Access 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/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 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
RE: [LegacyUG] View & Edit Legacy Data in MS Access
I've been meaning to do the same but I can't find any of the tables. Do you know where they are? Graham From: Don Quigley [mailto:dwquig...@cox.net] Sent: 02 March 2015 17:27 To: legacyusergroup@LegacyUsers.com Subject: [LegacyUG] View & Edit Legacy Data in MS Access 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/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
Re: [LegacyUG] View & Edit Legacy Data in MS Access
ALWAYS Back up the file (File > Backup File) before even *looking* at the tables in Access - for fear of inadvertent change. Sincerely, Sherry Technical Support Legacy Family Tree On Mon, Mar 2, 2015 at 9:26 AM, Don Quigley 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 > 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