What is an ACCDT file?
A file with .accdt extension is a Microsoft Access database template file that contains pre-defined database elements. These elements are a collection of structures that define a database applications such as database schemas for storing data, layout description for views of the data, and metadata describing the database. Being template files, ACCDT files can be used to create databases based on the template settings available in these. Resultant database files are saved as ACCDB files and populated with data in tables. Microsoft Access 2007 and onwards can open ACCDT files.
ACCDT File Format
ACCDT template files are based on the Office Open XML specifications and all the data is contained in the a ZIP package. Structure and contents information of the database is contained in the XML files and text files and linked to each other via relationships. You can rename an ACCDT file to .zip extension and use any compression software to extract the contents of the ZIP archive.
File structure
ACCDT files are packages that contain a collection of related parts. Each part stores information about the contents of a database application using XML, text and binary formats, that includes:
- Database objects
- Associated metadata
- Structure of the package
Package
A Package is a ZIP archive that contains multiple parts and conforms to the Open Packaging Conventions specified in ISO/IEC-29500-2. ACCDT files must contain atleast one Template metadaa part which should be the target of a relationship. This Template Metadata is the starting part of an ACCDT file.
Part
A part is a stream of bytes that has an associated type for specifying the nature and type of content stored in it. Parts enumeration specify valid parts, valid content types, and required relationships between all parts in a package.
Relationship
Package Relationship - where target is a part and the source is the package as a whole.
Part-to-Part Relationship - where the target is a part and the source is a part in the package.
Explicit Relationship - where a resource is referenced from the contents of a source part by referencing a relationship element by the value of its ID attribute.
Implicit Relationship - a relationship that is not explicit.
Internal relationship - where the target is a part in the package.
External relationship - where the target is an external resource not in the package.
How to open ACCDT file?
Since ACCDT file is related Microsoft Access (version 2007 or newer), you must install it on your computer to open it.
Open Microsoft Access. Click on File > Open, navigate to the AACDT file, and select it. The file will load as a template, allowing you to create a new database based on its structure.
