Access
Ross-spencer (Talk | contribs) (Initial outline for Microsoft Access) |
Ross-spencer (Talk | contribs) m (Link to Microsoft samples at Microsoft.com) |
||
| Line 37: | Line 37: | ||
== Sample Files == | == Sample Files == | ||
| − | * [http:// | + | * [http://office.microsoft.com/en-ca/templates/results.aspx?qu=access&queryid=64492973-33dd-48c8-a228-6ffdf681fad6&avg=zac Microsoft.com: Sample Database Templates] |
| − | * [https://isda.ncsa.uiuc.edu/NARA/CSR/php/search/formats.php?&cInput=mdb&srg=1&cName=default_extension&fid=866&fd=1&asc=1&num1=1 Conversion Software Registry: Sample Access | + | * [http://www.utterangel.com/UtterAngel/utterangel.aspx?cat=acc utterangel.com: Sample Access Databases and Applications] |
| + | |||
| + | * [https://isda.ncsa.uiuc.edu/NARA/CSR/php/search/formats.php?&cInput=mdb&srg=1&cName=default_extension&fid=866&fd=1&asc=1&num1=1 Conversion Software Registry: Sample Access Databases] | ||
== References == | == References == | ||
Revision as of 18:46, 2 February 2013
Access released by Microsoft also known as Jet DB is a standalone database that forms part of the Microsoft Office Suite of productivity tools. It was first released in 1992.
Access databases are composed of multiple page types. The length of these pages depends on the version of the Jet Database employed by the specific version of Microsoft Access. The first page of Access 95/97 and Access 2000/2003 databases is always a Database Definition Page.
Contents |
Microsoft Access 95/97 - Jet 3 Database
Microsoft Access 95/97 utilizes the Jet3 database engine. The page size of the Jet3 database engine is 2048 bytes.
Microsoft Access 2000/2002 - Jet 4 Database
Microsoft Access 2000/2003 utilizes the Jet 4 database engine. The page size of the Jet4 database engine is 4096 bytes.
Internal structure of the format
The Jet DB version can be found in the file header by reading the 4 byte little-endian integer at offset 0x13. Jet3 databases have a value of 0. Jet 4 databases have a value of 1.
The version and build number of Access, used to create the file is located variable in the file structure. It will be located within a 'Page Index' page type, under one of the memo fields stored within that page type.
The block of data at offset 0x18 running for 126 bytes (Jet 3) and 128+ bytes (Jet 4) represents RC4 encrypted data. It is thought this uses the key: 0x6b39dac7.
Specifications
A formal specification from Microsoft has not been made available. The following links are attempts by third parties to reverse engineer and document the format:
