<html><head></head><body><div style="color:#000; background-color:#fff; font-family:HelveticaNeue-Light, Helvetica Neue Light, Helvetica Neue, Helvetica, Arial, Lucida Grande, sans-serif;font-size:13px"><div id="yui_3_16_0_ym19_1_1473683939811_12754">Hi Tobin</div><div id="yui_3_16_0_ym19_1_1473683939811_12758"></div><div id="yui_3_16_0_ym19_1_1473683939811_12756" dir="ltr">I 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: <a id="yui_3_16_0_ym19_1_1473683939811_12905" href="http://www.database-preservation.com/">http://www.database-preservation.com/</a></div><div id="yui_3_16_0_ym19_1_1473683939811_12850" dir="ltr"></div><div id="yui_3_16_0_ym19_1_1473683939811_12848" dir="ltr">Kind regards,</div><div id="yui_3_16_0_ym19_1_1473683939811_12846" dir="ltr">Ole</div><div id="yui_3_16_0_ym19_1_1473683939811_12844" dir="ltr"></div><div id="yui_3_16_0_ym19_1_1473683939811_12842" dir="ltr">Ole Villadsen</div><div id="yui_3_16_0_ym19_1_1473683939811_12836" dir="ltr">Liaison Librarian, Engineering and Science</div><div id="yui_3_16_0_ym19_1_1473683939811_12838" dir="ltr">Carnegie Mellon University</div><div id="yui_3_16_0_ym19_1_1473683939811_12906" dir="ltr">ovillads@andrew.cmu.edu</div><div id="yui_3_16_0_ym19_1_1473683939811_12907" dir="ltr"></div><div class="qtdSeparateBR" id="yui_3_16_0_ym19_1_1473683939811_12663"><br><br></div><div class="yahoo_quoted" id="yui_3_16_0_ym19_1_1473683939811_12913" style="display: block;"> <div id="yui_3_16_0_ym19_1_1473683939811_12912" style="font-family: HelveticaNeue-Light, Helvetica Neue Light, Helvetica Neue, Helvetica, Arial, Lucida Grande, sans-serif; font-size: 13px;"> <div id="yui_3_16_0_ym19_1_1473683939811_12911" style="font-family: HelveticaNeue, Helvetica Neue, Helvetica, Arial, Lucida Grande, sans-serif; font-size: 16px;"> <div id="yui_3_16_0_ym19_1_1473683939811_12910" dir="ltr"> <font id="yui_3_16_0_ym19_1_1473683939811_12909" face="Arial" size="2"> <hr size="1" id="yui_3_16_0_ym19_1_1473683939811_12948"> <b><span style="font-weight:bold;">From:</span></b> "Magle,Tobin" <Tobin.Magle@colostate.edu><br> <b><span style="font-weight: bold;">To:</span></b> "rdap@mail.asis.org" <rdap@mail.asis.org> <br> <b><span style="font-weight: bold;">Sent:</span></b> Wednesday, September 7, 2016 4:01 PM<br> <b><span style="font-weight: bold;">Subject:</span></b> [Rdap] Archiving data in a Microsoft access database<br> </font> </div> <div class="y_msg_container" id="yui_3_16_0_ym19_1_1473683939811_12929"><br><div id="yiv9714795774">
<style><!--
#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;}
--></style>
<div id="yui_3_16_0_ym19_1_1473683939811_12928">
<div class="yiv9714795774WordSection1" id="yui_3_16_0_ym19_1_1473683939811_12927">
<div id="yui_3_16_0_ym19_1_1473683939811_12926">
<div id="yui_3_16_0_ym19_1_1473683939811_12925">
<div id="yui_3_16_0_ym19_1_1473683939811_12924">
<div id="yui_3_16_0_ym19_1_1473683939811_12923">
<div id="yui_3_16_0_ym19_1_1473683939811_12922">
<div id="yui_3_16_0_ym19_1_1473683939811_12921">
<div id="yui_3_16_0_ym19_1_1473683939811_12920">
<div id="yui_3_16_0_ym19_1_1473683939811_12919">
<div id="yui_3_16_0_ym19_1_1473683939811_12918">
<div id="yui_3_16_0_ym19_1_1473683939811_12917">
<div id="yui_3_16_0_ym19_1_1473683939811_12916">
<div class="yiv9714795774MsoNormal" id="yui_3_16_0_ym19_1_1473683939811_12915" style="margin-bottom:12.0pt;"><span style="font-size:11.0pt;color:#1F497D;">Hi all,
</span></div>
<div class="yiv9714795774MsoNormal" id="yui_3_16_0_ym19_1_1473683939811_12931" style="margin-bottom:12.0pt;"><span id="yui_3_16_0_ym19_1_1473683939811_12933" style="font-size:11.0pt;color:#1F497D;">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.</span></div>
<div class="yiv9714795774MsoNormal" id="yui_3_16_0_ym19_1_1473683939811_12936" style="margin-bottom:12.0pt;"><span id="yui_3_16_0_ym19_1_1473683939811_12938" style="font-size:11.0pt;color:#1F497D;">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.
</span></div>
<div class="yiv9714795774MsoNormal" id="yui_3_16_0_ym19_1_1473683939811_12940" style="margin-bottom:12.0pt;"><span style="font-size:11.0pt;color:#1F497D;">Thanks,</span></div>
<div class="yiv9714795774MsoListParagraph" style="margin-bottom:12.0pt;">
<span style="font-size:11.0pt;color:#1F497D;"><span>-<span style="font:7.0pt;">
</span></span></span><span style="color:#1F497D;">Tobin</span></div>
<div class="yiv9714795774MsoNormal"><span style="font-size:11.0pt;color:#1F497D;"> </span></div>
<div class="yiv9714795774MsoNormal"><span style="font-size:11.0pt;color:#1F497D;">C. Tobin Magle, PhD</span></div>
<div class="yiv9714795774MsoNormal"><span style="font-size:11.0pt;color:#1F497D;">Data Management Specialist</span></div>
<div class="yiv9714795774MsoNormal"><span style="font-size:11.0pt;color:#1F497D;">Morgan Library</span></div>
<div class="yiv9714795774MsoNormal"><span style="font-size:11.0pt;color:#1F497D;">1019 Campus Delivery</span></div>
<div class="yiv9714795774MsoNormal"><span style="font-size:11.0pt;color:#1F497D;">Fort Collins, CO 80523-1019</span></div>
<div class="yiv9714795774MsoNormal"><span style="font-size:11.0pt;color:#1F497D;">(970) 491-0517</span></div>
<div class="yiv9714795774MsoNormal"><span style="font-size:11.0pt;color:#1F497D;"><a href="mailto:tobin.magle@colostate.edu" target="_blank" rel="nofollow" ymailto="mailto:tobin.magle@colostate.edu"><span style="color:#0563C1;">tobin.magle@colostate.edu</span></a></span></div>
</div>
<div class="yiv9714795774MsoNormal"><span style="font-size:11.0pt;color:#1F497D;"> </span></div>
<div class="yiv9714795774MsoNormal" style="margin-bottom:12.0pt;"><br>
<br>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div><br>_______________________________________________<br>Rdap mailing list<br><a href="mailto:Rdap@mail.asis.org" ymailto="mailto:Rdap@mail.asis.org">Rdap@mail.asis.org</a><br><a href="http://mail.asis.org/mailman/listinfo/rdap" target="_blank">http://mail.asis.org/mailman/listinfo/rdap</a><br><br><br></div> </div> </div> </div></div></body></html>