You might want to take a look at Clooz Version 1 to get an idea of how this program works. I am one of the beta testers for the Version 2 that is expected to be out shortly. From the description that you have provided of what you want and how you have arranged your files at the present, you might find that Clooz, especially Version 2, will do a lot for you and to be honest, it is much cheaper than you investing your time to create something that might be already done and that you can utillize.
Dick -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Olds-Wills-Hodges-Harris Sent: Sunday, February 05, 2006 12:35 AM To: [email protected] Subject: [LegacyUG] MS-Access use with Legacy I just picked up MS-Access 2003 with the intent of using it to create indexes of my files. I have 8 file categories: newspaper clippings, photographs, documents, voice/video recordings, correspondence, city directories, census extracts, heirlooms. Each category has a unique file number prefix and each item in every category is assigned a file number. For instance, I have photographs numbering from P-0001 to P-0847; I have newspaper clippings numbering from N-0001 to N-0985; I have documents numbering from D-0001 to D-0770; and so on. Does anyone know if there is anything available from Legacy or elsewhere that explains how/where certain elements of data can be located in the Legacy database using MS-Access? For instance, I would like to extract from Legacy the RIN, First Name/MI, Last Name, Married Name, and User ID to read into the database I'm creating for the various file categories. I have used ASCII before when transferring data between programs but needed to know field sizes and so forth, I "think" I would need similar field size and location information from Legacy to accomplish my intent. It appears as if Legacy has data segmented into a collection of tables. Is there a description available that explains the type of data each table contains? If there is anyone on the list who has created or is using a similar database system for their files I'd like to hear from you. Thanks Gary Enter the drawing for a FREE Legacy Cruise to Alaska or a FREE research trip to Salt Lake's Family History Library. Open to users of Legacy 6 Deluxe. Enter online at http://legacyfamilytree.com/FreeTrip.asp Legacy User Group guidelines can be found at: http://www.LegacyFamilyTree.com/Etiquette.asp To find past messages, please go to our searchable archives at: http://www.mail-archive.com/legacyusergroup%40mail.millenniacorp.com/ To unsubscribe please visit: http://www.legacyfamilytree.com/LegacyLists.asp Enter the drawing for a FREE Legacy Cruise to Alaska or a FREE research trip to Salt Lake's Family History Library. Open to users of Legacy 6 Deluxe. Enter online at http://legacyfamilytree.com/FreeTrip.asp Legacy User Group guidelines can be found at: http://www.LegacyFamilyTree.com/Etiquette.asp To find past messages, please go to our searchable archives at: http://www.mail-archive.com/legacyusergroup%40mail.millenniacorp.com/ To unsubscribe please visit: http://www.legacyfamilytree.com/LegacyLists.asp
