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
