Using AI to speed up development (1 Viewer)

[RaptorRaptur]

Hi,
Has anyone out there used any form of AI to improve/speed up Access development?

If so, did it really help?
What AI tool did you use.
Was the time saved greater that the AI learning time?

 

[amorosik]

Claude, ChatGpt, CoPilot
I currently only use them with their text prompt, for functions, SQL queries, and similar
I'd like to understand how to have complete projects reviewed for anomalies or to get recommendations for improvements
I mean, once an entire project has been extracted with one of the many VCS systems, and therefore you have a series of text files describing forms, modules, reports, queries, send everything to the AI, asking it to analyze and improve the procedures that can be improved.

 

[RonPaii]

I have been using it as a linter and for code review to refactor my code. Once it has my code I can ask specific questions for development. Also upload a document describing your coding standards.

 

[amorosik]

I have been using it as a linter and for code review to refactor my code. Once it has my code I can ask specific questions for development. Also upload a document describing your coding standards.

What system did you use (Claude Antropic, ChatGpt openAi, etc.)?

How did you provide the code?
(All in a directory, everything in a zip file, etc...)

How was the modified code returned?

 

[RonPaii]

Copilot and ChatGpt.
I upload the text files generate by the Joyfullservice source control add-on.
You could also copy and paste.
Small code, copy and paste otherwise download.

 

[dalski]

In Visual Studio I enabled CoPilot; was helpful in correcting my errors in C# as half a decade since I looked at C#, & sometimes I couldn't make out what it was doing.

 

[amorosik]

Copilot and ChatGpt.
I upload the text files generate by the Joyfullservice source control add-on.
You could also copy and paste.
Small code, copy and paste otherwise download.

Can you upload 50-100 Mbyte of files?

 

[amorosik]

In Visual Studio I enabled CoPilot; was helpful in correcting my errors in C# as half a decade since I looked at C#, & sometimes I couldn't make out what it was doing.

Yes, CoPilot and Visual Studio are tightly integrated, and the combination is truly effective
Unforunately, we alway have to be last with access

 

[RonPaii]

Can you upload 50-100 Mbyte of files?

I am uploading modules so not the entire FE.

 

[amorosik]

Ah ok, but you think that an entire project, for example 50-100 Mbyte, can be analyzed/correct/revised?

 

[RonPaii]

Ah ok, but you think that an entire project, for example 50-100 Mbyte, can be analyzed/correct/revised?

I ask Copilot, it said it could handle that much but cannot open an accdb. It recommends giving it .bas/.cls uploads. As for speed I think you would have time to make a nice dinner for all your friends while it works on it.

 

[GPGeorge]

What I do is export the files to GitHub and provide the AI (Claude in my case) the Raw URL's for those files. Claude needs to have access to the GitHub repo, so I created one just for that purpose. It also can't get to files in the repo directly, but it can retrieve them via the Raw URLs.

 

[amorosik]

What I do is export the files to GitHub and provide the AI (Claude in my case) the Raw URL's for those files. Claude needs to have access to the GitHub repo, so I created one just for that purpose. It also can't get to files in the repo directly, but it can retrieve them via the Raw URLs.

Ok but how you say to Claude "..the file is here.." in the Github repo ?

 

[RonPaii]

Ok but how you say to Claude "..the file is here.." in the Github repo ?

Are the files in a public repository, or do you need to provide credentials to Claude?

 

[amorosik]

If needed, I can put them on Github
It's even better if they're just on my local PC
What I still can't do is allow Claude to read a series of files physically present on any PC

 

[GPGeorge]

Are the files in a public repository, or do you need to provide credentials to Claude?

It's a public repository.

 

[GPGeorge]

Ok but how you say to Claude "..the file is here.." in the Github repo ?

"Hey, Claude. Use the raw files in this GitHub Repo: https://github.com/GPGeorge/Context_LTFLibrary.

The raw URLS are in the file called LTFCatalogRawURLs in that Repo. Discard any files you may have retrieved in earlier sessions. Use only these latest versions."