4 ms·
Maybe you can use Access as the front end to SQLite? During my internship 25 years ago I build a system to register aircraft accidents and near accidents. This
by ako 7y ago
Maybe you can use Access as the front end to SQLite?
During my internship 25 years ago I build a system to register aircraft accidents and near accidents. This system used access 1.0 (Windows 3.1) as the front end, storing the data in Oracle 6, I think connected through Odbc.
- lstamour 7y agoYup, ODBC still works: https://support.office.com/en-us/article/administer-odbc-data-sources-b19f856b-5b9b-48c9-8b93-07484bfab5a7 https://support.office.com/en-us/article/administer-odbc-dat... though because this is Microsoft and we can’t have nice things, it might not: https://docs.microsoft.com/en-us/office/troubleshoot/access/cannot-use-odbc-or-oledb https://docs.microsoft.com/en-us/office/troubleshoot/access/... For SQLite there’s https://github.com/softace/sqliteodbc https://github.com/softace/sqliteodbc but at that point I might pick a different DB for a more established ODBC driver. Or just use Access...
- Bombthecat 7y agoBut this requires admin access to install? No?
- lawzup 7y agoyes it requires admin access