A Microsoft Access .accdb or .mdb file on this computer: read-only queries with row and time limits; changes wait for approval.
The screenshots show GateRook 2.0.0: the Microsoft Access form, the endpoint selector, and this connector’s actual tool preview. The form and preview have not been saved. Select a screenshot to open it at full size.
1. Create a connection and enter the settings
In GateRook, open Connections, select Add connection, search for Microsoft Access, choose its card and select Continue to configure. GateRook downloads the official Microsoft Access connector module when you choose it. Wait for the download and verification to finish before configuring the connection.
Have an existing Microsoft Access database file on this computer. This connector opens the file directly; password-protected Access files are not supported.
Choose a file you are allowed to inspect. An approved change writes to that file, so use a copy when you want to explore without affecting the original database.
Enter a Name, for example microsoft-access-demo. Your AI app uses this name to choose the connection.
Choose Database file or enter its path, for example ~/Documents/orders.accdb. You must choose the file yourself.
Under Limits, set suitable Max rows and Statement timeout values. No database-server host, port or account is needed for this file connection.
Choose Development, Staging or Production to match the service. Review the connector’s limit and access settings before continuing.
2. Test the connection and add it to an endpoint
Select Continue to test. GateRook checks the settings from your computer. Review the result and resolve any connection, certificate or permission error before continuing.
For an unreadable file, check the path, permissions, file format and whether the file is password-protected. A saved query may depend on features outside the connector’s supported Access SQL; start by inspecting a normal table.
After the test passes, select Continue to add to an endpoint. Choose the endpoint your AI app uses, review its tool modes, then select Save connection. GateRook offers default as the starter endpoint.
3. Use the connection from your AI IDE
After saving Microsoft Access on the endpoint and passing its connection test, ask your AI app to use microsoft-access-demo, or the name you chose. If its tools are missing, confirm the endpoint assignment and refresh the MCP connection or start a new chat.
For this local-file connection, file permissions and configured path restrictions determine which data can be read or changed.
The preview below shows this connector’s default tools before saving. The table explains what each tool can do; connection settings, credentials and endpoint policies can restrict access further.
Start with a small read request. Replace example resource names with existing resources your connection may access. Open Activity after the call to inspect its connection, tool, arguments, policy decision and result metadata.
Ask your AI, for example
- “List the tables and saved select queries in microsoft-access-demo.”
- “Describe the columns and indexes of Orders in microsoft-access-demo.”
- “Using microsoft-access-demo, count orders by status without changing the Access file.”
| Tool | What it does | Starts as |
|---|---|---|
access_list_tables | The tables and saved select queries of the Access file, with their kind. | Read only |
access_describe_table | The columns of one table or saved query with their types, sizes, nullability, defaults and AutoNumber, its primary key and its indexes. | Read only |
access_query | Runs one SELECT or WITH … SELECT in Access SQL ([names in brackets], 'text' or "text", #dates#, IIf, Nz, Format, DateAdd …) on the Access file, with row and time limits. GateRook opens the file read-only and runs the query in a read-only transaction. SELECT … INTO, LOAD_FILE, domain functions (DLookup, DSum …), NEXT VALUE FOR, FOR UPDATE and JDBC escapes are refused. | Read only |
access_execute | Runs one INSERT, UPDATE or DELETE, or CREATE TABLE, ALTER TABLE, DROP TABLE or CREATE INDEX on the Access file, only after a person approved exactly this statement, and writes it to the file once. LOAD_FILE, domain functions, queries, routines and rights are refused. A change is never retried. | Approval |
You can change each tool’s mode on the endpoint. Every call your AI makes appears in Activity.