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.

5 comments
Comment actions Permalink

You can try with JDBC driver, for example: http://ucanaccess.sourceforge.net/site.html

But DataGrip was never tested in that environment.

0
Comment actions Permalink

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.

0
Comment actions Permalink

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.

0
Comment actions Permalink

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:

jackcess-2.1.11.jar
ucanaccess-4.0.4.jar
hsqldb-2.3.1.jar
commons-logging-1.1.3.jar
commons-lang-2.6.jar
0

Please sign in to leave a comment.