Is it possible to access a Microsoft Access (.accdb) database from Datagrip?
Answered
This is a need for college work, as there are few options to access this type of database on Linux.
Please sign in to leave a comment.
You can try with JDBC driver, for example: http://ucanaccess.sourceforge.net/site.html
But DataGrip was never tested in that environment.
Maxim, is there perhaps an issue open for that? Access, whilst the bastard-child of the database landscape, indeed would be a nice supplementation of the vast selection of 'real' databases found in DataGrip.
The closest is: https://youtrack.jetbrains.com/issue/DBE-6253
UCanAccess works in part; you can set up a data source and browse the database structure. In spite of that, the IDE fails at performing introspection to be able to validate table and column names in SQL queries (tested in IntelliJ IDEA 2019.3).
It would be really great if this could be made to work.
Also introspection seems to work now. I copied the jars from the maven-dependencies inside the project to a folder and added this as a user driver: