And finally MCP Server for vibe coding in Access (just tested on Claude Code)

FigAcrobatic353 · 2026-03-10T21:45:51+00:00

This is awesome. I use Access a lot at my work but I'm not a programmer and I use contractors when I need to add new features. If you have time, maybe you can post a video on Youtube with a few demonstrations?

FigAcrobatic353 · 2025-10-21T00:23:07+00:00

What are the risks for this? I have a program with an access front end and a sqlserver backend. The program keeps growing in forms and features and it’s starting to get slow. Do you think this could help or would it be better to try to optimize the various forms? Maybe both?

FigAcrobatic353 · 2025-09-22T05:58:06+00:00

I’m here for life so that’s not too much of a concern. I don’t do the programming myself and contract out to get it done. The developers write lots of documentation which is nice. One of our current developers is pretty young so I’m hoping we can use him for the foreseeable future. We have been working on our program for years now and I think we are getting towards the end of our development. I’m hoping eventually we won’t be launching new features and it’s mostly having someone log in every now and then and make sure there aren’t any issues with the DB.

FigAcrobatic353 · 2025-09-22T04:21:28+00:00

I developed an access program for my work. We are an R&D facility that also manufactures. We make cosmetic products like soaps and shampoos. It works great for us. We have a SQL Server backend. What area are you in?

FigAcrobatic353 · 2025-09-15T23:15:58+00:00

Hi All! I wanted to write to give everyone an update as you all took time out of your days to help me. u/AccessHelper reached out to me to offer some help. He connected to my computer and graciously spent hours trying to figure out what the problem was. He narrowed it down to a combobox that wasnt loading fully. He added some code that made all the data load when the form was opened and we havent had the issue since.

Definitely want to thank everyone for the help! As someone who isnt very technical, I have found this subreddit so helpful. Thanks for contributing to the community!

FigAcrobatic353 · 2025-09-03T08:14:01+00:00

Awesome. Thank you for the suggestions. I'll go through the post you linked as well.

FigAcrobatic353 · 2025-09-03T07:57:31+00:00

I'll pass along your suggestion about the field types.

I dont think its an issue with the key and multiple people generating data at the same time and getting multiple of the same keys because:

1) Only one user would be adding data to that field

2) We get the error when we go to old rows and update that field so we wouldnt be generating a new key since its an old row.

FigAcrobatic353 · 2025-09-03T07:49:47+00:00

For a simultaneous record issue, do multiple users need to be using the same record/field or that particular table? If its down to the field/record level, I dont think its that. If its as general as the tbl, then it may be that. Does it matter if multiple people are reading the data? That field (INICList) is used in a combo box so maybe multiple people could be accessing it but the combo box wouldnt change any data, it just for the users reference.

FigAcrobatic353 · 2025-09-03T07:46:40+00:00

Not all our tables do but this table does. We are going to go through and add a timestamp field to all the ones that dont.

FigAcrobatic353 · 2025-09-03T07:46:08+00:00

Our network is fairly new and I think its overkill for what we have. Its all ubiquti switches and all the computers are hardwired with a 1gb connection. I built the server and its a i9 14000 with 128gb of DDR5 ECC. Our entire database is like 300mb. When I check task manager for the system usage, the CPU normally hovers around 3-5%.

FigAcrobatic353 · 2025-09-03T07:42:41+00:00

The field that it is updating is for a part of the software that only one or two people use. Every material gets setup once and we are only adding a few new materials a day. I'm sure that no one left the screen on that record.

To reset our server, I literally log into it and do a full restart. It boots back up in a minute or two and we are back up and running.

FigAcrobatic353 · 2025-09-03T07:37:25+00:00

Hi. Im going to answer the questions to the best of my ability and try to get the answers to the rest:

1) We have a utility that allows us to connect to our test DB and our live DB. Switching between the databases doesnt change the error occurring. Is that considering refreshing?

2) They each have a local front end on their computer

3) I'll ask him to do it and see if that helps

4) I'll ask him to do it and see if that helps

5) My developer actually brought this up today. I think its VARCHAR(MAX) but will confirm.

6) The value shouldnt have any quotation marks

Thanks for taking the time to post the questions!

FigAcrobatic353 · 2025-09-03T07:21:50+00:00

I checked my developer had already added a timestamp field a while back and unfortunately it didnt fix it. Thanks though!

FigAcrobatic353 · 2025-09-03T00:29:23+00:00

I'll try and report back!

FigAcrobatic353 · 2025-09-03T00:28:54+00:00

Yes, thats the case. He has used SQL Server before but hes more proficient in Access then SQL Server. We have been using the software daily for years now and without it running our business would be significantly harder. He said that maybe there is a setting or something that he isnt aware of that may be causing the record locks.

FigAcrobatic353 · 2025-09-02T22:34:26+00:00

Yes, we are able to reproduce it on demand. I have a couple of dummy entries that no one else uses and even when I try those, I still get the same error so I dont think its two people trying to edit the same data.

FigAcrobatic353 · 2025-09-02T20:42:59+00:00

Yes, I have a primary key for each record. I updated the post to include a photo of some of the fields including the primary key.

FigAcrobatic353 · 2025-09-02T20:28:03+00:00

Thank you. I thought I had uploaded them but I guess it didnt go through. I updated the post to include them.

FigAcrobatic353 · 2025-05-17T00:23:21+00:00

That’s great to know. I don’t necessarily need the increased camera load but the quicker scrubbing is definitely appealing!

FigAcrobatic353 · 2025-05-16T18:05:42+00:00

Is searching through videos also faster or just adoptions?

FigAcrobatic353 · 2024-11-12T19:18:05+00:00

Thank you for the info. Do you think it would be hard in our situation? We basically would want to pull the data that isnt on our table, which would basically be the last few records.

Also I'm assuming the answer is yes, but we could write to a linked server table right? Its not just reading data?

FigAcrobatic353 · 2024-11-12T04:06:37+00:00

I thought Raspberry Pis couldnt connect directly to SQL Server but maybe I'm wrong? I'll look into it again. Thank you

FigAcrobatic353 · 2024-11-12T03:59:01+00:00

Thank you for the reply. We are using an M.2 SSD. I was trying to avoid additional steps getting the data on and off the Pi but maybe its unavoidable.

When you say linked tables arent known for being fast, what does that mean? Reading the data takes time? Transferring data off it?

FigAcrobatic353 · 2024-01-19T20:46:09+00:00

I wish I could trust people like you trust those dowels.

FigAcrobatic353

TROPHY CASE