[Rdap] Archiving data in a Microsoft access database

Ole Villadsen villadso at yahoo.com
Mon Sep 12 09:03:17 EDT 2016


Hi TobinI came across the Database Preservation Toolkit, a tool designed to export and preserve relational databases, during the 2015 iPRES conference in Chapel Hill.  You can read more about it here:  http://www.database-preservation.com/Kind regards,OleOle VilladsenLiaison Librarian, Engineering and ScienceCarnegie Mellon Universityovillads at andrew.cmu.edu

      From: "Magle,Tobin" <Tobin.Magle at colostate.edu>
 To: "rdap at mail.asis.org" <rdap at mail.asis.org> 
 Sent: Wednesday, September 7, 2016 4:01 PM
 Subject: [Rdap] Archiving data in a Microsoft access database
   
 <!--#yiv9714795774 _filtered #yiv9714795774 {font-family:Wingdings;panose-1:5 0 0 0 0 0 0 0 0 0;} _filtered #yiv9714795774 {font-family:"Cambria Math";panose-1:2 4 5 3 5 4 6 3 2 4;} _filtered #yiv9714795774 {font-family:"Calibri Light";panose-1:2 15 3 2 2 2 4 3 2 4;} _filtered #yiv9714795774 {font-family:Calibri;panose-1:2 15 5 2 2 2 4 3 2 4;}#yiv9714795774 #yiv9714795774 p.yiv9714795774MsoNormal, #yiv9714795774 li.yiv9714795774MsoNormal, #yiv9714795774 div.yiv9714795774MsoNormal {margin:0in;margin-bottom:.0001pt;font-size:12.0pt;font-family:"Times New Roman", serif;}#yiv9714795774 a:link, #yiv9714795774 span.yiv9714795774MsoHyperlink {color:blue;text-decoration:underline;}#yiv9714795774 a:visited, #yiv9714795774 span.yiv9714795774MsoHyperlinkFollowed {color:purple;text-decoration:underline;}#yiv9714795774 p.yiv9714795774MsoListParagraph, #yiv9714795774 li.yiv9714795774MsoListParagraph, #yiv9714795774 div.yiv9714795774MsoListParagraph {margin-top:0in;margin-right:0in;margin-bottom:0in;margin-left:.5in;margin-bottom:.0001pt;font-size:12.0pt;font-family:"Times New Roman", serif;}#yiv9714795774 p.yiv9714795774msonormal0, #yiv9714795774 li.yiv9714795774msonormal0, #yiv9714795774 div.yiv9714795774msonormal0 {margin-right:0in;margin-left:0in;font-size:12.0pt;font-family:"Times New Roman", serif;}#yiv9714795774 span.yiv9714795774EmailStyle18 {font-family:"Calibri", sans-serif;color:#1F497D;}#yiv9714795774 .yiv9714795774MsoChpDefault {font-family:"Calibri", sans-serif;} _filtered #yiv9714795774 {margin:1.0in 1.0in 1.0in 1.0in;}#yiv9714795774 div.yiv9714795774WordSection1 {}#yiv9714795774 _filtered #yiv9714795774 {} _filtered #yiv9714795774 {font-family:"Calibri", sans-serif;color:#1F497D;} _filtered #yiv9714795774 {font-family:"Courier New";} _filtered #yiv9714795774 {font-family:Wingdings;} _filtered #yiv9714795774 {font-family:Symbol;} _filtered #yiv9714795774 {font-family:"Courier New";} _filtered #yiv9714795774 {font-family:Wingdings;} _filtered #yiv9714795774 {font-family:Symbol;} _filtered #yiv9714795774 {font-family:"Courier New";} _filtered #yiv9714795774 {font-family:Wingdings;}#yiv9714795774 ol {margin-bottom:0in;}#yiv9714795774 ul {margin-bottom:0in;}-->Hi all, I was speaking with a researcher today about putting a large dataset into our repository. Part of the data is stored in a Microsoft access database. I know that we can export individual tables and store them as .csv/.tsv files for preservation, but the researcher is concerned about losing the linkages from the tables to raw data files (in this case interview audio) that are stored in Access. Has anyone encountered similar situations? If so, is there a straightforward way to preserve these links? I was thinking of hand linking them somehow through metadata, but I wanted to get some external advice first. Thanks, -         Tobin    C. Tobin Magle, PhD Data Management Specialist Morgan Library 1019 Campus Delivery Fort Collins, CO 80523-1019 (970) 491-0517 tobin.magle at colostate.edu    

 
_______________________________________________
Rdap mailing list
Rdap at mail.asis.org
http://mail.asis.org/mailman/listinfo/rdap


   
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mail.kunverj.com/pipermail/rdap/attachments/20160912/7129494f/attachment-0001.html>


More information about the RDAP mailing list