I have a MySQL database that downloads data into a Microsoft Access application and need to create an API connection with OpenAI or other AI model. I already have an API connection with a form on the Microsoft Access database where the user can enter a question about something on the screen, and the form references the record and fields in the database that the user sees. The API with the data must enable the AI model to lookup the relevant info in the database in order to respond to the user's question. This can be done either through the MySQL on a shared server in the cloud or directly with each instance of the Microsoft application on the user's computer.
