kAccess
1.0.0.8
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 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
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
- 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 (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 |