AI Options (2 Viewers)

[RaptorRaptur]

I have been fooling around with AI.
Which AI option is "most in tune" with MS Access?
Also, is anyone else getting frustrated with ChatGPT losing its memory when it, for no reason I can establish, just resets the page and the chat record is gone"
I find it is pretty good at Access but doesn't seem fully aware of differences between Access versions

 

[The_Doc_Man]

The AI - like me, these days - sometimes gets confused about specifics. We have seen "Chattie" give you VB answers for a VBA problem. Or VBScript answers. Look at some of Uncle Gizmo's posts on AI as he describes the torturous path he has explored trying to get an answer about some algorithm. Have you ever seen a 6-year-old playing "organized" kids soccer? They run screaming up and down the field, but are likely to stop a moment and marvel at the butterfly they just frightened, and will chase that instead of the ball. Many of the AI platforms are likely to do the computer equivalent.

 

[AccessBlaster]

You could try Co-pilot it's a Microsoft program that's integrated in 365.

From what I have read the paid versions of AI does better with the memory issues you describe.

 

[MarkK]

I once asked an AI why it sucks so bad at VBA, and it explained that VBA is wrapped in a file type that requires opening an application, so it has (and it stressed this point) far fewer code examples to consult.

 

[The_Doc_Man]

I once asked an AI why it sucks so bad at VBA, and it explained that VBA is wrapped in a file type that requires opening an application, so it has (and it stressed this point) far fewer code examples to consult.

WOW! You got a relatively straight answer from it. I'm impressed.

 

[MarkK]

You got a relatively straight answer from it. I'm impressed.

If you experience AI as sweet-talking you, ask harder questions. If you ask AI to validate your process, it will, even if that process has glaring deficiencies. I increasing ask AI how my process sucks, and how it's likely to fail.

AI is like a mirror.

 

[solar]

As with Copilot...be specific. Start with the Access software version you are using. If it don't know that your software version it may make assumptions that you are using an older version of Access.
Example:

Microsoft Access-365 version database [or whatever exact version you are using].
Then....
Write a brief detailed explanation about your project problem to solve (the goal), such as a set of key points A, B, C, D).
Then ask the key question to your problem. Know your problem and know what you want for a goal to that problem.
You must ALSO be alert when the AI is going astray...because any AI will go down a rabbit hole big time, or literally go in circles!
If you are logged in to a Microsoft account it can remember some parts about what you are working on earlier (though that won't be useful if you dive into a different goal or project).
If you know the problem but not the solution, ask for suggested solutions, and AI will provide you with 3-4 possible choices. Then you pick one of those and ask it for more details. As the AI proceeds you can determine if that choice is the logical solution for your database problem.
Remember, AI is backward looking intelligence, while humans are forward looking intelligence (creativity, out-of-the box thinkers), and that is your advantage over a machine.

 

[RaptorRaptur]

You could try Co-pilot it's a Microsoft program that's integrated in 365.

From what I have read the paid versions of AI does better with the memory issues you describe.

Funny enough, I've had more problems since upgrading to paid

 

[RaptorRaptur]

If you experience AI as sweet-talking you, ask harder questions. If you ask AI to validate your process, it will, even if that process has glaring deficiencies. I increasing ask AI how my process sucks, and how it's likely to fail.

AI is like a mirror.

I'm getting somewhat pissed off by the constant condescending "encouragement" from AI

 

[RaptorRaptur]

Further to my other posts, I have found it useful to send ChatGPT the documenter file on everything in my project and tell it to remember. However, the next time AI sends me, for example, an invitation to choose a voice or to choose between the way AI should "talk" to me, ChatGPT gets confused

 

[The_Doc_Man]

I'm getting somewhat pissed off by the constant condescending "encouragement" from AI

You find AI condescending? Here you are, attributing a human communication style to what is essentially an inanimate object. Is there a chance that the condescension is simply that the AI answered your questions in an abrupt, rather coldly factual, almost machine-like style?

 

[Edgar_]

Which AI option is "most in tune" with MS Access?

None is objectively better, but Claude tends to be relatively better at code in most languages, and it has come up with more elegant solutions for me in VBA and other languages too.

Also, is anyone else getting frustrated with ChatGPT losing its memory when it, for no reason I can establish, just resets the page and the chat record is gone"

You need to familiarize with context size, which is the amount of things it can remember. It comes to a point where it won't know what you were doing to begin with, so it's good to throw reminders here and there. The app sugarcoats its deficiencies through its sycophantic ways, so it's hard to know when it no longer knows what's up. Additionally, when the conversation gets too big, ask it to write a summary of key points in the conversation and start a new one, it will respond faster and with better memory and context available. It is highly important to summarize things that haven't worked in particular.

I find it is pretty good at Access but doesn't seem fully aware of differences between Access versions

Indeed

I'm getting somewhat pissed off by the constant condescending "encouragement" from AI

Ask it to not be sycophantic, Claude is better at that

Further to my other posts, I have found it useful to send ChatGPT the documenter file on everything in my project and tell it to remember. However, the next time AI sends me, for example, an invitation to choose a voice or to choose between the way AI should "talk" to me, ChatGPT gets confused

Next time, instead of sending the documenter file, send pure text. Create a routine that outputs table name and field names, it's very good inferring the type of field. Same for queries, output that instead.

 

[DickyP]

You could try Co-pilot it's a Microsoft program that's integrated in 365.

From what I have read the paid versions of AI does better with the memory issues you describe.

The only thing I've tried with Co-pilot before I switched it off was MS Word where it tried to replace good English with gibberish!

 

[The_Doc_Man]

Word + CoPilot was bad for me, too. As an amateur writer, I sometimes deal with characters who speak in an area-related patois. If you think W+CP is funky for good English, try it with dialog from a fictional character with an accent.