The Death of ActiveX: How to Build a CRUD Tree of Accounts in MS Access WITH MCP

[ayamnash]

how to build a fully functional Tree of Accounts (Chart of Accounts) in Microsoft Access using a modern, native approach—completely avoiding legacy ActiveX controls.
Traditional TreeViews in Access are often broken by Windows updates or bit-version (32-bit vs 64-bit) conflicts. By leveraging the MCP Server for Microsoft Access Control, I've developed a solution that is 100% stable, secure, and easy to maintain.
Key Features:
* Native Architecture: Built entirely with standard Access forms and subforms—no external dependencies or OCX files.
* Full CRUD Support: Easily Add, Edit, and Delete accounts directly within the tree hierarchy.
* Dynamic Relationships: Powered by self-referencing SQL tables managed through the MCP interface.
* AI-Orchestrated: Using the create_form_from_llm_text and write_vba_module tools to automate the design and logic.
Tools Used (via MCP):
* create_table: To establish the Parent-Child data structure.
* create_form_from_llm_text: To generate the custom UI layout.
* write_vba_module: To handle the recursive logic for account expansion and data integrity.
* run_query: For seamless data updates across the hierarchy.
*create report
Why No ActiveX?
ActiveX is considered legacy technology. By going native, this application is:
* Future-proof: Works on both 32-bit and 64-bit Office.
* Secure: No "ActiveX Disabled" security warnings for your users.
* High Performance: Native controls load faster and use less memory.
Check out the MCP Repository here:

https://github.com/ayamnash/MCP_server_ms_access_control
YouTube video on how to use MCP لbt Antigravity IDE

 

[Gasman]

Very nice.
I tried to add a record, as you can see, but it did not position where I expected it?
I was beleieving that the account code would do that?

Also whilst the is Primary starts with main, the other options are arabic, and I have no idea as to what they mean. I tried to edit and select first arabic entry, but it did not make a difference to the position of Cozume.?

Where did I go wrong?

 

[ayamnash]

1211003 isprimary =sub not main
If you look at1211002 account it is. Sub account

I will re upload database not contains arabic characters

 

[Gasman]

Is there anyway, when you refresh, you can determine, how the tree is shown, and keep it that way?

PITA when you have to drill down again.
I have tried both the arabic entries, but it does not move.

 

[ayamnash]

I apologize for your previous question;
perhaps I did not quite understand what you meant. However, when you selected the father, it should be administration buildings

Regarding your second question, I used mcp server to explain the problem, and it solved it. See the attached file.
I encourage you to try using mcp server to see its benefits.

youtube video