Best Approach for CRUD Operations on MS Access Database from Mendix
0
Hi everyone, I’m exploring options for integrating Mendix with an MS Access database. Specifically, I’d like to perform CRUD operations and retrieve data from MS Access into my Mendix application. I understand that one possible solution is to use a custom Java action to handle the interaction with MS Access. Additionally, I’ve come across mentions that the existing DB Connector module in Mendix can potentially be extended or modified to establish a connection to an MS Access database. Could anyone share insights, best practices, or examples of how this can be achieved? Are there specific libraries or configurations required for these approaches? Furthermore, are there any caveats or limitations to be aware of when working with MS Access in this context? Any guidance or recommendations would be greatly appreciated. Thanks in advance!