kAccess
1.0.0.3
Read and write Microsoft Access databases (.mdb and .accdb) from PowerShell 7 on Windows, Linux and macOS. It is pure PowerShell: no Access, no ACE/ODBC driver and no Java. Create databases and tables with indexes, and add, change and delete rows. A port of Jackcess.
Minimum PowerShell version
7.2
Installation Options
Owners
Copyright
(c) 2026 kalmstrom.com. MIT License; contains a port of Jackcess (Apache 2.0).
Package Details
Author(s)
- Peter Kalmstrom
Tags
Access MSAccess accdb mdb Jet ACE Database Jackcess CrossPlatform Linux macOS Windows
Functions
New-kAccessDatabase Get-kAccessTable Get-kAccessRow Add-kAccessRow Set-kAccessRow Remove-kAccessRow New-kAccessTable Remove-kAccessTable Rename-kAccessTable New-kAccessRelationship
PSEditions
Dependencies
This module has no dependencies.
Release Notes
1.0.0.3: creating a table with a text index is much faster (the text sort codes load on demand; 17 s -> about 5 s on a busy Windows server). 1.0.0.2: seven example scripts (examples folder): quick start, CSV import, sales database with keys and a relationship, data maintenance, folder inventory, export to CSV and JSON, format conversion. 1.0.0.0: first release - read tables and rows, create databases, tables, indexes and relationships, add / change / delete rows (bulk), delete and rename tables.
FileList
- kAccess.nuspec
- LICENSE
- README.md
- examples\01-Quick-Start.ps1
- examples\02-Csv-To-Access.ps1
- examples\03-Sales-Database.ps1
- examples\04-Maintain-Data.ps1
- examples\05-Database-Inventory.ps1
- examples\06-Export-Everything.ps1
- examples\07-Convert-Format.ps1
- jackcess-codes\NOTICE.txt
- jackcess-codes\index_codes_ext_gen.txt
- jackcess-codes\index_codes_ext_genleg.txt
- jackcess-codes\index_codes_gen.txt
- jackcess-codes\index_codes_genleg.txt
- jackcess-templates\NOTICE.txt
- jackcess-templates\empty.mdb
- jackcess-templates\empty2003.mdb
- jackcess-templates\empty2007.accdb
- jackcess-templates\empty2010.accdb
- jackcess-templates\empty2016.accdb
- jackcess-templates\empty2019.accdb
- kAccess.psd1
- kAccess.psm1
Version History
| Version | Downloads | Last updated |
|---|---|---|
| 1.0.0.8 | 10 | 11/18/2026 |
| 1.0.0.3 (current version) | 13 | 11/15/2026 |
| 1.0.0.2 | 14 | 11/15/2026 |
| 1.0.0.1 | 12 | 11/15/2026 |