Microsoft Access
The desktop database in Microsoft 365: tables, forms and reports in a single file, for small teams and office tools. See how developers rate it month by month on DTDb.
- Category
- database engine
- Developer
- Microsoft
- Created by
- —
- First release
- 1992
- License
- Proprietary
- Open source
- No
- Pricing
- Paid
- Website
- https://www.microsoft.com/microsoft-365/access
- Written in
- —
- Data model
- Relational
- Storage layout
- Row-oriented
- Workload
- Transactions (OLTP)
- Analytics architecture
- Not an analytics platform
- Query language
- Access SQL
- ACID transactions
- Yes
- Schema
- Strict
- Deployment
- Embedded
- Scaling
- Single node
- Create, read, update, delete
- Create: moderate (Fine for small files, 2 GB per file); Read: moderate (Fast locally, slow over a network share); Update: moderate (Page locks, a handful of users at a time); Delete: moderate (Compact and repair reclaims the space)