kAccess

1.0.0.8

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, read saved queries as SQL, and read and write attachments, multi-value fields and Date/Time Extended values, create attach
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, read saved queries as SQL, and read and write attachments, multi-value fields and Date/Time Extended values, create attachment and multi-value columns, and read and write encrypted (password-protected) files, and create saved queries from SQL. A port of Jackcess.
Show more

Minimum PowerShell version

7.2

Installation Options

Copy and Paste the following command to install this package using PowerShellGet More Info

Install-Module -Name kAccess

Copy and Paste the following command to install this package using Microsoft.PowerShell.PSResourceGet More Info

Install-PSResource -Name kAccess

You can deploy this package directly to Azure Automation. Note that deploying packages with dependencies will deploy all the dependencies to Azure Automation. Learn More

Manually download the .nupkg file to your system's default download location. Note that the file won't be unpacked, and won't include any dependencies. Learn More

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 Get-kAccessQuery New-kAccessQuery Add-kAccessRow Set-kAccessRow Remove-kAccessRow New-kAccessTable Remove-kAccessTable Rename-kAccessTable New-kAccessRelationship Get-kAccessAttachment Add-kAccessAttachment Remove-kAccessAttachment Get-kAccessMultiValue Add-kAccessMultiValue Remove-kAccessMultiValue

PSEditions

Core

Dependencies

This module has no dependencies.

Release Notes

1.0.0.8: New-kAccessQuery creates saved queries from SQL (select, make-table, append, update, delete, crosstab, union, data definition, pass-through) that Access opens; encrypted files can be written as well (-Password on every command). 1.0.0.7: encrypted / password-protected files are read with -Password (Jet RC4 .mdb, Office RC4, CryptoAPI RC4, AES and Agile AES .accdb; read only); New-kAccessTable creates ATTACHMENT and MULTI_VALUE columns with the hidden tables Access makes for them. 1.0.0.6: attachment and multi-value fields - Get-, Add- and Remove-kAccessAttachment, Get-, Add- and Remove-kAccessMultiValue; Date/Time Extended (EXT_DATE_TIME) columns are read and written, exact to 100 ns, and New-kAccessTable creates them in Access 2019 files. 1.0.0.4: Get-kAccessQuery lists the saved queries with their SQL text (select, crosstab, union, make-table, append, update, delete, pass-through, data-definition). 1.0.0.3: creating a table with a text index is much faster (the text sort codes load on demand: 17 s -> 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

Version History

Version Downloads Last updated
1.0.0.8 (current version) 10 11/18/2026
1.0.0.3 13 11/15/2026
1.0.0.2 14 11/15/2026
1.0.0.1 12 11/15/2026