Using AI to speed up development (2 Viewers)

[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."

 

[RaptorRaptur]

Hi All,
I think AI is going to put MANY corporate programmers onto the unemployment register.

I have been playing with free Co pilot and have set it some tasks.
Although I haven't checked the code, it has generated more code in 45 seconds than I could have done in a week.
At the moment it is still supplying SQL and supposed VBA code (Although it uses some things unacceptable to Access and VBA. Just one silly example is that VBA rejects its usage of -- for comments.

On one small module I was able to get its code to work after about 30 minutes.

I think that, at present, it will provide a worrying competitor to what I terms as "maintenance programmers" but is still a way off challenging the need for good systems analysts/Creative programme designers.

I love the way CoPilot delivers a solution and then suggests improvements it can make. In one very late night, I burned through 80% of my free usage for the month.

Has anyone else out there made any really productive use of CoPilot?

 

[RonPaii]

I have been using it for refactor and lint.
This week it came in handy for refactoring some C# code that interfaces with the Autodesk Vault API. This API is poorly documented and the public example code is largely outdated.

 

[Isaac]

well I know this isn't 'Access', but I use it a lot for refactoring T-SQL and converting T-SQL to Snowflake SQL, it's quite good once I learned a few gotcha's and now instruct ChatGPT to avoid those pitfalls.

One of the things I have enjoyed leveraging is the limitless amount of granularity you can include in telling ChatGPT's memory about how you want your SQL formatted. I have seen a lot of SSMS add-ons in my day, Redgate's SQL Prompt being the main one, but absolutely nothing - no tool in the world - compares with my ability to verbosely tell ChatGPT every minute detail about how I want it to format code. I could even tell it to produce a line break after x-number of characters in an IN clause specifically, or put every individual boolean expression in a where clause on the new line, etc.
That's one reason I use ChatGPT and not an AI tool without a memory, to me without a memory is worthless - my whole productivity gain IS about the memory