Valentijn at 13:42, 5 October 2023

2023-10-05T13:42:04Z

Valentijn: Commonalities in preservation methods for Microsoft Access databases

2023-09-28T13:49:01Z

Commonalities in preservation methods for Microsoft Access databases

New page

{{Infobox COW
|status=Production
|tools=CSV export form for Microsoft Access
|input=Access databases submitted to digital repositories.
|output=CSV files for long-term preservation and dissemination of the data tables from Microsoft Access files.
|organisation=SEADDA community of archaeologists and digital specialists
|organisationurl=https://www.seadda.eu/
}}
==Workflow Description==



[[File:workflow.png|Textual description]]<br>



For .mdb the ADS has a Java Package that exports all tables as .CSV with “” text qualifiers. For .accdb the Digital Archivist manually exports each table a .CSV with “” text qualifiers.

DANS developed an Access form and makes use of this to export all tables from .mdb and .accdb files. See the linked tool 'CSV export form for Microsoft Access'.

The SND exports Access tables to CSV and additionally disseminates the data as XML files.

The archivists will check and ensure for the presence of the necessary documentation to understand and reuse the data tables.

==Purpose, Context and Content==


In practice, Microsoft Access is widely used for creating databases. However, the MDB and ACCDB Access formats are very poorly supported outside of the commercial Microsoft Access. Due to the different versions of these formats, it may even be that Access itself does not always support the files properly.

Within the SEADDA consortium, workflows for dealing with the preservation of Microsoft Access databases were examined from three long standing digital repositories for archaeological data: the Archaeology Data Station of Data Archiving and Networked Services (DANS), the Swedish National Data Service (SND), and the Archaeology Data Service (ADS).

Each repository uses exports of the Access data tables to CSV files as the method for preservation and dissemination.

==Evaluation/Review==


==Further Information==

https://docs.google.com/document/d/1mAL20vvhZnYkZuc_60awac5wc-kiaBzYZ_AJahS_nkM/edit?usp=sharing


[[User:Valentijn|Valentijn]] ([[User talk:Valentijn|talk]]) 13:49, 28 September 2023 (UTC)

@@ Line 37: / Line 37: @@
 ==Further Information==
 <!-- Provide any further information or links to additional documentation here -->
-https://docs.google.com/document/d/1mAL20vvhZnYkZuc_60awac5wc-kiaBzYZ_AJahS_nkM/edit?usp=sharing
+https://doi.org/10.11141/ia.67.3
 <!-- Add four tildes below ("~~~~") to create an automatic signature, including your wiki username. Ensure your user page (click on your username to create it) includes an up to date contact email address so that people can contact you if they want to discuss your workflow -->

Workflow:Preserving Access databases - Revision history

Valentijn at 13:42, 5 October 2023

Valentijn: Commonalities in preservation methods for Microsoft Access databases