Is it possible to access a Microsoft Access (.accdb) database from Datagrip?
已回答
This is a need for college work, as there are few options to access this type of database on Linux.
请先登录再写评论。
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: