Access JumpStart 2.0 | Blog

A Rapid Development Framework for Microsoft Access

In my message yesterday, I installed the SDOpenAI plugin:

Pair programming with AI – SDOpenAI – installing the plugin

Today I setup an OpenAI API account (I had already done this in the past so I was beyond the free trial). I purchased $10 worth of resource. The pricing is hard to understand in terms I can apply to how I’ll use it. It’s billed in the number of tokens you request / receive from the API and which API bot you ask. Smarter bots tend to cost more than the simpler bots. I’m currently using OpenAI 4o – Mini. It’s the cheapest one per token, is one of the newest, but is simpler than the non-mini version. I don’t really have much of an inkling of the difference other than that simple explanation they had on the site.

So, it looks like the mini OpenAI intelligence would be good for pretty basic function generation. I haven’t tried the more expensive one yet. They are orders of magnitude different in cost. like $5 for 4o for the same number of tokens that cost $0.015 for the mini version. I suspect the more expensive one might provide better coding results by orders of magnitude as well.

I did have a problem with the SDOpenAI plugin itself. It seems to be conflicting with the AccessDev plugin for Advanced Find & Replace. Either of them seems to easily crash when I try to use it when they are both active.

A second problem is that if I deactivate the SDOpenAI plugin in order to use the AccessDev plugin the free trial license gets blown away and I have to uninstall and reinstall the plugin to get it to work again.

I’m also not sure how well it will understand my full code base. I’m thinking based on my experiments so far that it’s somewhat limited in scope. I’m not sure how to tell it to look at my tables or whether it understands the table structures I already have. I also use various classes and want to be able to ask it to suggest tests to code for RubberDuck and if it can suggest design patterns to use to make testing simpler.

More to come… Thanks for your time today!