How to refactoring an Access project with AI - for example with LM Studio ?

[amorosik]

I'm testing LM Studio and the various available templates
LM Studio also offers the ability to be controlled externally via API, and I believe this opens the door to a wide range of uses
Suppose we wanted to run an analysis to identify any errors or areas for improvement for a large project, say a few hundred forms, a few hundred reports, and dozens of code modules, all exported in text format from one of the various VCS systems
How exactly should we proceed?
How do we send the various files to LM Studio and receive the analyzed and corrected files in response?

 

[CJ_London]

Doesn't answer your question, but I've used AI to map a project - how forms/queries/reports/modules etc relate to each other. Simplistically generating a flow chart. As you say download using saveastext (or save as unicode8) then inspect all forms for subforms, all code for calls to open a form or report, change a subform sourceobject etc.

I did this using co-pilot to manage the export and generate the inspection code in VBA. It populates a relationships type table and identifies objects/code no longer used, but does not identify errors or suggested areas of improvement. They both require context and perspective which would have to be provided (assuming by errors you don't mean compile errors). I use the relationships table to identify potential improvements in process flow from the users perspective.