Hi there! :)

[unmateria]

Hi there! Im new on here... an spanish old Access lover (well, not so old, just near 50 hahahah).
I like to help other people and in this times of Claude Code, and I made public an MCP for Access (just a personal project for personal use... refactoring my 29 years old Access ERP hahahhaha... you can imagine the chaos inside it...) and since I think it can help a lot to many people (with the MCP or just long Access experience), Im just here to listen and help.
Thank you and good weekend!

 

[Jon]

Welcome to Access World! We're so happy to have you join us as a member of our community. As the most active Microsoft Access discussion forum on the internet, with posts dating back more than 20 years, we have a wealth of knowledge and experience to share with you.

We're a friendly and helpful community, so don't hesitate to ask any questions you have or share your own experiences with Access. We're here to support you and help you get the most out of this powerful database program.

To get started, we recommend reading the post linked below. It contains important information for all new users of the forum:

https://www.access-programmers.co.uk/forums/threads/new-member-read-me-first.223250/

We hope you have a great time participating in the discussion and learning from other Access enthusiasts. We look forward to having you around!

 

[NauticalGent]

Welcome aboard!

 

[theDBguy]

Hola. Bienvenidos a AWF!

 

[The_Doc_Man]

Hello and welcome to the forums.

 

[tvanstiphout]

I am a user of your MCP, and I am impressed with it, and your quick response if I find a bug. Great to see you here!

 

[unmateria]

Hey Tom! thank u man is ur MCP too! solving that bug let me solve more things!!
Thank u everybody, we will keep in contact

 

[Isaac]

Hi there! Im new on here... an spanish old Access lover (well, not so old, just near 50 hahahah).
I like to help other people and in this times of Claude Code, and I made public an MCP for Access (just a personal project for personal use... refactoring my 29 years old Access ERP hahahhaha... you can imagine the chaos inside it...) and since I think it can help a lot to many people (with the MCP or just long Access experience), Im just here to listen and help.
Thank you and good weekend!

Welcome to the AWF !! Sounds like you are making great use of AI. Refactoring an old system is a real labor of love, as it involves a tediousness that's so different than creating fresh design - good luck to you!

 

[Richard Rost]

Welcome! Always good to see another long-time Access developer in the trenches.

I’ve been hearing more and more about MCP lately, but I haven’t had a chance to really dig into it yet. The idea of using AI to help refactor and tame a decades-old Access application definitely caught my attention. That’s a special kind of project right there.

I’ve been doing a fair amount of AI integration with Access myself using the OpenAI API. I can send up database schema and have it generate SQL and even some basic VBA. Right now I’m working on getting it to go a step further and start modifying forms and reports.

If you don’t mind sharing at a high level, how are you hooking MCP into Access? Are you exposing your database through some kind of API layer, or doing something more direct?

Either way, sounds like a very cool project. Looking forward to hearing more about it.

 

[unmateria]

Hi Richard MCP 'attacks' the Access via DCOM, so you can call it "directly". Check the tools on the readme on github, so you can imagine how the LLM will work with it. Of course the model u use with the MCP is very important... I recommend sonnet or opus (Im not related to anthropic in any way... sometimes i look like an anthropic vendor lol).

The MCP was just for me, for refactor and rebuild a 29 years old ERP the growed uncontrolled (by me, with little time, and very bad architecture... the typical that begins focused on some objectives and finally is used for 1000 more things). The results are stupidly good... like 200k lines of code was migrated, forms rebuilt, a proper AI system integrated, and 1000 more integrations (from the web page to whatsapp integration passing for tools for work and design or Apps for android for the ERP using my other b4a MCP) in less than 2 weeks (with me only as developer).

I’ve been doing a fair amount of AI integration with Access myself using the OpenAI API. I can send up database schema and have it generate SQL and even some basic VBA. Right now I’m working on getting it to go a step further and start modifying forms and reports.

About this... I have tested mostly anything and I built a lot of things (I even finetuned some models with the full ERP schema, rules, etc... was a hell), most of them with more or less success... but no one perfect until I went claude cli (with -p) + chromadb + MCP . That way is stupidly sucessful and powerful. You can tell him to learn from the errors or slow paths or high token consumption paths, and he will modify his own MCP or his own chromadb to be more powerful each time... and is cheap as hell (a single 20€/month account for everything, except OCR, which I use with gemini pro via openrouter... about 0.10€ each COMPLEX PDF or 0.03 using QWEN3VL for simpler ones).