Microsoft Access Quick Facts

About Quick Facts Tables

Format Type Identifier

MDB_ADO

Reader/Writer

Both

Licensing Level

Professional and above

Dependencies

  • File versions prior to 2007: None, but the format is available only on Windows.
  • File versions 2007 or newer: install a corresponding or newer version of Microsoft Office, or the free download of Microsoft Access Database Engine 2010 Redistributable.

Dataset Type

Database

Feature Type

Table name

Typical File Extensions

Not applicable

Automated Translation Support

Yes

User-Defined Attributes

Yes

Coordinate System Support

No

Generic Color Support

No

Spatial Index

Never

Schema Required

Yes

Transaction Support

Yes

Encoding Support

Yes

Geometry Type

db_none

Microsoft Access Geometry Support

Geometry

Supported?

aggregate

no

circles

no

circular arc

no

donut polygon

no

elliptical arc

no

ellipses

no

line

no

none

yes

point

no

polygon

no

raster

no

solid

no

surface

no

text

no

z values

n/a