I am moving my Microsoft Access database over to Retool, and using Retool Database as my new back end. However, as Retool doesn’t offer nice printable reports, I need to connect Microsoft Access to Retool Database to keep on printing reports from Access until such a type as Retool offers nice report building and printing.
Gemini suggests getting a PostgreSQL ODBC driver. PostgreSQL ODBC Driver for Windows, macOS, and Linux: Download connector for integration and sync Does this actually work? Just wanting to confirm this is the right path before I go and spend the money.
I understand that if I want to connect a variety of services to my backend, I should move to something like Azure SQL. But all I want to do is print 2 or 3 reports a week from MS Access, so I don’t want to buy and manage another subscription just for that. Especially if Retool eventually gives us the reporting features us MS Access users are used to…