Microsoft Access Database

Evaluates a VBA/Access expression via Application.Eval. Works with: domain functions (DLookup, DCount...), built-in VBA functions (Date(), Len()...), form properties of OPEN forms (Forms!frmX.Prop), public functions in standard modules. Does NOT work with: class instances (even default/predeclared), variables, Subs. For class instances use access_run_vba with a wrapper function, or this tool will attempt an automatic fallback via a temp VBA module.

Executes multiple SQL statements in a single call. Each statement can be SELECT (returns rows, default limit 100 — adjustable via 'limit') or INSERT/UPDATE/DELETE (returns affected_rows). stop_on_error=true stops at first error. DELETE/DROP/TRUNCATE/ALTER require confirm_destructive=true.

Executes SQL via DAO. SELECT returns JSON rows (default limit: 500). INSERT/UPDATE return affected_rows. DELETE/DROP/ALTER require confirm_destructive=true.

Generates Markdown with database structure: modules with signatures, forms, reports, queries, macros. Writes to disk and returns the content.

Exports form/report/module as text (SaveAsText). Does NOT open in Design view — does not recalculate positions. File is UTF-16 LE.

Go-to-definition for a VBA symbol — the mirror of access_find_usages. Scans every standard module, form code-behind and report code-behind for DECLARATIONS of `symbol` and returns where each lives (object_type, object_name, line, declaration, scope, value if constant). Detects: const, enum, enum_member, type, type_field, sub, function, property (Get/Let/Set, incl. Default Property), declare (Win32 API), and module-level variable. Handles multi-const lines (Const A=1, B=2) and joins VBA line continuations (` _` at end of line). Use this when you need the value of a constant/enum member, or the …

Searches for text or regex in VBA, query SQL and control properties (ControlSource, RecordSource, RowSource, SourceObject, DefaultValue, ValidationRule, LinkChildFields, LinkMasterFields). Returns results grouped: vba_matches, query_matches, control_matches. A vba_match on a statement continued with ' _' also carries statement_line, end_line and content_full (the whole statement joined). Each control_match carries control_name, property, the full (joined) value and the line in the export. For Caption/Tag/Filter/OrderBy, other properties or a single form, use access_search_controls instead.

Reads code/definition of an Access object. Modules: .bas code. Forms/reports: internal format (props + VBA). Macros: SaveAsText XML-like representation (Action/RunCommand blocks); pair with access_set_code to round-trip. Queries: SQL + DAO properties. For reading specific VBA procedures, prefer access_vbe_get_proc (faster, smaller output).

Full definition (Begin...End) of a control by name. `raw_block` is the UNABRIDGED definition exactly as Access exports it — go here when you need a property access_list_controls does not return (OnClick, StatusBarText, Format, ConditionalFormat...). Note that inside raw_block a long value is still split across quoted continuation lines, the way Access wrote it.

Reads a database property (CurrentDb.Properties) or Access option (GetOption).

Reads all properties of a field: DefaultValue, ValidationRule, Description, Format, etc.

Reads properties of a form or report (RecordSource, Caption, DefaultView, HasModule, etc.). object_type ('form' or 'report') is required. If property_names is omitted, returns all readable properties. Pass 'section' to read a section's properties instead.

Imports form/report/module from text (LoadFromText). REPLACES if exists. Does NOT open in Design view — does not recalculate positions. For forms/reports with CodeBehindForm: separates VBA automatically and injects via VBE (same as access_set_code).

NOT a designer and NOT aesthetics — expect zero 'good design' from this. It is a deterministic checker of the OBVIOUS, mechanically-verifiable stuff only (a seatbelt, not a stylist). Returns structured JSON violations the agent should fix BEFORE declaring a layout done: contrast (WCAG white-on-white etc.), overlap, out-of-bounds, text truncation, sibling inconsistency, misalignment, zero-size/invisible. summary.verdict is PASS / REVIEW / FAIL. Static (one export, no Design view). measure='auto' tries Access WizHook for exact text width and falls back to a heuristic. The same engine runs automa…

Lists controls of a form/report with name, type, caption, control_source, position. Long property values that Access splits across several quoted lines in the export are returned joined, so control_source/caption are always the WHOLE value. Use `fields` to keep only the keys you need (e.g. ["name","control_source"]) — a 60-control form is mostly geometry. For a property this tool does not return, read the control's raw_block with access_get_control.

Lists indexes of a table: name, fields, primary, unique, foreign.

Lists linked tables with source_table, connect_string, is_odbc. name='X' returns only that table (exact, case-insensitive); names_only=true gives a light listing without connect strings (use it when there are hundreds of links and the full dump overflows); mask_password=true masks PWD=... in the returned connect strings.

Lists database objects by type (table, module, form, report, query, macro, all). System tables (MSys*, ~*) are filtered out. Macros are fully supported as a regular object_type — combine with access_get_code / access_set_code / access_run_macro for end-to-end macro workflows.

Lists VBA references: name, GUID, path, is_broken, built_in.

Lists relationships between tables: name, tables, fields, cascade flags.

Lists the 14 common startup options with their current values.

Creates or deletes an index. create requires fields [{name, order?}]. primary/unique optional.

Manages QueryDefs: create, modify, delete (requires confirm=true), rename, get_sql. create/modify require sql.

Adds (add) or removes (remove) a VBA reference. add: requires guid or path. remove: requires name.

Reads or sets the TabIndex of controls on a form/report. Actions: 'get' (returns controls grouped by section, ordered by TabIndex), 'set' (assigns TabIndex 0..N-1 in the order of `tab_order`), 'auto_renumber' (re-sequences current TabIndex values to be contiguous 0..N-1 — useful after deleting controls). Skips controls that don't support TabIndex (Label, Line, Rectangle, Image, PageBreak).

Exports a report to PDF, XLSX, RTF or TXT. output_path auto-generated if omitted. Refuses to overwrite an existing file unless overwrite=true.

Changes the connect string of a linked table and refreshes. relink_all=true updates all tables with the same original connection. refresh=true re-reads the schema using the table's OWN connect string (no new_connect needed, password never dumped) — use after an ALTER TABLE on the server. Note: LoginTimeout=8 is injected into new_connect so a bad string fails fast instead of hanging on a modal login dialog, so the returned new_connect differs from the one you sent.

Executes an Access macro by name.

Executes a VBA Sub/Function. Supports 3 syntaxes: 'Module.MySub' (standard module via Application.Run), 'MySub' (same), 'Forms.FormName.Method' (form module via COM — form must be open). Returns result if Function. With timeout, automatically dismisses MsgBox/InputBox if exceeded.

Captures the Access window as PNG. Optionally opens a form/report before capturing. Returns path, dimensions and metadata. wait_ms pumps Windows messages (Timer events, ActiveX init).

Searches text or regex in the control properties of every form/report (ControlSource, RowSource, DefaultValue, ValidationRule, SourceObject, LinkChild/MasterFields, Caption, Filter, OrderBy, Tag by default; properties=["all"] searches every property of the block, e.g. OnClick or StatusBarText). Values split across continuation lines in the export are joined BEFORE matching, so a term that falls across the split is still found. Each hit carries the owning control, the property, the full value and the line in the export (use access_get_code to read around it). Form/report-level properties come b…

Searches a text string in any Text/Memo field of any LOCAL table. Skips system tables (MSys*, ~*) and linked tables. Returns matches grouped by table with an excerpt around each hit. Use `tables` to restrict the scan to a list of table names. Jet LIKE is case-insensitive by default; pass match_case=true to filter the result set further. Results are capped per-table and total.

Searches for text or regex in the SQL of ALL queries. Returns [{query_name, sql}].

Imports code into the database. Overwrites if exists, creates if not. Call access_get_code first to read the original. For forms/reports: supports CodeBehindForm/CodeBehindReport (VBA is injected via VBE). For object_type='macro': accepts the SaveAsText representation (round-trip with access_get_code). For object_type='class_module': creates a VBA class module (adds VERSION 1.0 CLASS header automatically if missing). Automatic backup and restore on import failure.

Modifies properties of a control via COM. Numeric/boolean values are converted automatically.

Sets a database property or Access option. Creates the property if it does not exist.

Sets a field property. Creates the property if it does not exist.

Sets form/report-level properties (RecordSource, Caption, DefaultView, HasModule, etc.) via COM in Design view. Pass 'section' to set properties of a section instead (BackColor, Height, Visible, ...).

Modifies properties of multiple controls on a form/report in a single operation. Opens in Design view once, applies changes, saves and closes.

Table structure via DAO: fields, types, size, required, record_count, is_linked.

Tips and gotchas for working with Access via MCP. Topics: eval, controls, gotchas, sql, vbe, compile, design_vbe, macros, lint, layout, design, subform_tabcontrol. Without topic returns the list.

Import/export data between Access and Excel/CSV. file_type: xlsx or csv. range only for Excel, spec_name only for CSV.

Click at image coordinates on the Access window. Coordinates are relative to a previous screenshot (image_width required for scaling).

Types text or sends keyboard shortcuts to the Access window. Use 'text' for normal text, 'key' for special keys (enter, tab, escape, f1-f12, etc.), 'modifiers' for combinations (ctrl, shift, alt).

Appends code to the end of a VBA module.

Static structural check of the ALREADY OPEN VBA project — the safe alternative to access_compile_vba, which decompiles first and can discard unsaved VBA. Detects unbalanced If/For/Do/While/Select/With/Type/Enum blocks, code outside a procedure and misplaced Option statements. It is NOT a compiler: it does not resolve identifiers, types or references, so ok=true does not prove the project compiles.

Searches for text or regex in ONE specific VBA module. Returns matches [{line, content, proc}]. Each match includes 'proc' (procedure name). Optional: proc_name to limit search to a single procedure. When the matched line belongs to a statement continued with ' _', the match also carries statement_line, end_line and content_full (the whole statement joined, trailing comments removed) — 'content' alone is only the matched PHYSICAL line, so read content_full before judging a wrapped statement (an API Declare's return type lives on its last continuation line). To search ALL modules/forms/reports …

Reads a range of lines from a VBA module via VBE COM. Provide either count or end_line (not both).

Code of a VBA procedure by name. Returns start_line, body_line, count, code. start_line = VBE proc start, which INCLUDES the blank separator / comment lines above the proc (use it for whole-proc operations). body_line = the Sub/Function/Property declaration line itself (use it for line-range edits of the body).

Index of procedures in a VBA module: total_lines, procs [{name, start_line, body_line, count}]. start_line = VBE proc start (INCLUDES preceding blank/comment lines); body_line = the Sub/Function/Property declaration line.

Surgical find/replace WITHIN a VBA procedure. More efficient than replace_proc when only a few lines change in a large proc. patches: [{find, replace}]. ATOMIC BY DEFAULT (atomic=true): if any patch fails to match, nothing is written and you must re-send the WHOLE batch. Anchors are matched case-insensitively by default (match_case=false), because VBA is case-insensitive and the VBE rewrites casing on its own. proc_name='(Declarations)' targets the module declarations section.

Replaces lines in a VBA module via VBE. count=0: insertion. new_code='': deletion. Validates bounds automatically. Pass new code as new_code (a string) OR new_lines (a list of strings, joined with newlines — '' entries become blank lines). Batch mode: pass 'operations' (list of {start_line, count, new_code|new_lines}) to execute multiple operations in 1 call (auto-sorted bottom-to-top).

Replaces an entire VBA procedure by name (boundaries found via VBE). Preserves the blank separator line above the proc. new_code='' DELETES the proc (and its leading blank separator) — this is the supported way to delete a procedure.

Searches for text or regex in ALL VBA modules (modules, forms, reports) in the database. When a matched line belongs to a statement continued with ' _', the match also carries statement_line, end_line and content_full (the whole statement joined, trailing comments removed) — 'content' alone is only the matched PHYSICAL line, so read content_full before judging a wrapped statement (an API Declare's return type lives on its last continuation line).