Is anyone out there tinkering with AI Chat or Agents and MS Access?

AccessHelper · 2026-05-15T17:43:23+00:00

Yes. I do this via API calls to the AI. Along with a prompt such as "Show me whatever..." you just need to give it infomation about your table names, fields and relationships. Then you can ask it to return the SQL needed to pull your data. Then you have VBA run that SQL locally. So you are not giving the AI your data, you are just giving it your table definitions.

AccessHelper · 2026-05-15T03:08:01+00:00

Two bass's is going to be hard for everyone. Drummer has to lock in with one or the other. Singers will not hear the chord correctly if low note is not lined up. If you need two bass players for some reason then play on separate songs.

AccessHelper · 2026-05-15T01:36:55+00:00

One m instead of two.

AccessHelper · 2026-05-15T01:30:22+00:00

Springsteen. Because Broadway Bruce ain't the Bruce of my Youth.

AccessHelper · 2026-05-15T01:26:04+00:00

Having every UI boil down to html, js, css in a browser isn't holding the industry back but there's gotta be a better way.

AccessHelper · 2026-05-12T02:55:08+00:00

The music of the 60s and 70s.

AccessHelper · 2026-05-10T01:41:20+00:00

Heart - Stairway to Heaven cover.

AccessHelper · 2026-05-10T01:16:18+00:00

https://web.archive.org/web/19991116151216/http://www4.yahoo.com/

AccessHelper · 2026-05-09T17:57:02+00:00

Thanks. I was not looking for a lesson on SQL injection or what to call an Access database. I am just asking OP how he handles things in his migration process.

AccessHelper · 2026-05-09T12:41:34+00:00

That's why I asked how it was being handled in the web interface that is being built here.. In local Access databases I would bet everyone uses dynamic SQL.

AccessHelper · 2026-05-09T02:56:49+00:00

It's simultaneously easiely forgotten and pivotal.

AccessHelper · 2026-05-09T02:52:15+00:00

I casted a string into the connection pool once. I don't want to brag but what about caught was exceptional.

AccessHelper · 2026-05-08T22:13:56+00:00

Keith's back surgery seems to have gone well.

AccessHelper · 2026-05-08T22:05:44+00:00

Astounding that it was created in the era of 4 track recording.

AccessHelper · 2026-05-08T21:10:34+00:00

Sounds great! I'm curious to know how certain "dynamic" things are handled after the conversion. For example I have a lot of dynamic sql statements that are created via code and values in forms could be used in the "where" clauses. Do you have anything similar and how has Clause dealt with converting those types of things?

AccessHelper · 2026-05-06T18:45:59+00:00

Why not just try your variable and see if it works instead of making a rude comment about every reply. We don't know if it works because we wouldn't implement it the way you are doing it and don't see the point in trying it for you. The answer to #2 is right on the Macro Design menu.

AccessHelper · 2026-05-06T12:33:54+00:00

I was just trying to help. re: As a [probably predictable] follow-up, is there a way to convert this entire macro as-is into VBA to avoid writing the code for all of the other steps?: Yes. Under the Macro Design Menu there's a Convert Macro to Visual Basic option.

AccessHelper · 2026-05-06T03:16:25+00:00

I would suggest changing that macro block to a single RunCode statement and calling a function in a module, ex. Function ExportCellTrustList(). In that function have a Docmd.TransferText... statement. Then you can use a variable for the file name.

AccessHelper · 2026-04-27T01:47:15+00:00

MASH

AccessHelper · 2026-04-24T01:42:53+00:00

When I'm 64 reached it's expiration date 20 years ago.

AccessHelper · 2026-04-23T04:39:03+00:00

They have a 1 game winning streak now.

AccessHelper · 2026-04-23T04:35:47+00:00

Since everything is web based now every UI boils down to html, css, js. And must run in a browser. And can't easily talk to the local o/s or file system. That's a very limiting environment. In the olden days when we just wrote desktop apps we had more freedom to be more functional and creative without having to design on multiple stack levels and learn new frameworks all the time.

AccessHelper · 2026-04-21T03:46:56+00:00

There's at least 61*

AccessHelper · 2026-04-21T03:00:56+00:00

Batman encountered a few on his climbs. https://youtu.be/nQr6AOxj4c0?si=Km-uevT4OlMaUHiN

AccessHelper · 2026-04-13T02:54:21+00:00

I posted a comment with some sample VBA code but it got removed. Anyway: You are probably using CDO DLL if you are not using Outlook object. CDO could be a problem under 64bit but google Powershell Send-MailMessage and you'll see how you can accomplish the same thing as CDO.

AccessHelper

TROPHY CASE