Can AI agents automate Microsoft Access?
Microsoft · desktop · databaseproductivitylow-code
Automatable today, but only from a Windows machine with Access/ACE installed: the COM object model plus VBA covers app behavior and ACE ODBC/OLEDB gives full SQL access to the data, with several community MCP servers wrapping exactly that path. What is missing is any network API, webhook, or cloud connector, so remote/headless agents need a Windows worker in the loop.
Best path today: api · Overall automatability: 7/10
Modalities
| Modality | Status | Detail |
|---|---|---|
| API | partial | comodbcoledbdao coverage: full · docs |
| SDK | yes | vba official: yes |
| MCP | yes | verdict: community-only MCP-Access · maintained: True mcp-server-access-mdb · maintained: True OMNI-MS-Access-MCP · maintained: stale |
| Integrations | yes | power_automate |
| CLI | partial | |
| Extensibility | yes | vbacomaccess-macros webhooks: False |
| Data access | export: csv, xlsx, xml, pdf · import: csv, xlsx, xml, odbc | |
| RPA / UI automation | workable | win32msaauiapower-automate-desktopuipath Prefer data/COM paths over surface automation: Power Automate for desktop has first-party "Launch Access"/Access actions and ACE OLE DB SQL actions (64-bit ACE driver required). Access forms are custom-drawn canvases, so selector-based UI automation inside forms is weaker than driving the object model directly.
|
| Computer use | unknown | measured verdicts only — "unknown" means not yet probed by us |
Scores
| api | mcp | rpa | computer use | overall |
|---|---|---|---|---|
| 7 | 4 | 7 | — | 7 |
Evidence
| Fact | Tier | Source | Date |
|---|---|---|---|
modalities.api (COM automation surface) | declared | source | 2026-08-15 |
modalities.sdk + modalities.extensibility.scripting | declared | source | 2026-08-15 |
modalities.api.kinds (odbc/oledb via ACE engine, 64-bit requirement) | declared | source | 2026-08-15 |
modalities.api.kinds (ODBC from Python via ACE driver) | community | source | 2026-08-15 |
modalities.mcp.third_party | scraped | source | 2026-08-15 |
modalities.mcp.third_party | scraped | source | 2026-08-15 |
modalities.mcp.third_party | scraped | source | 2026-08-15 |
modalities.integrations.power_automate (desktop Access actions) | declared | source | 2026-08-15 |
modalities.integrations.power_automate (SQL against Access from desktop flows) | declared | source | 2026-08-15 |
modalities.cli (startup switches incl. /x macro) | declared | source | 2026-08-15 |
modalities.data_access (spreadsheet import/export/link via DoCmd.TransferSpreadsheet) | declared | source | 2026-08-15 |
Last verified 2026-08-15 · volatility low · JSON record