{var%20f='http://v.t.sina.com.cn/share/share.php?appkey=1515056452',u=z||d.location,p=['&url=',e(u),'&title=',e(t||d.title),'&source=',e(r),'&sourceUrl=',e(l),'&content=',c||'gb2312','&pic=',e(p||'')].join('');function%20a(){if(!window.open([f,p].join(''),'mb',['toolbar=0,status=0,resizable=1,width=440,height=430,left=',(s.width-440)/2,',top=',(s.height-430)/2].join('')))u.href=[f,p].join('');};if(/Firefox/.test(navigator.userAgent))setTimeout(a,0);else%20a();})(screen,document,encodeURIComponent,'','','https://www.manongdao.com/data/attach/logo/logo.png', '推荐 贪生不怕死 的问题《JDBC Driver for MsAccess which will work on Unix [》','https://www.manongdao.com/q-1045017.html','页面编码gb2312|utf-8默认gb2312'));){kind=link}
I need a JDBC driver for MsAccess to be used in a Unix environment
I would strongly prefer it to be an open-source
Also it should support SQL statements
(Jackcess came close to being my choice- but it doesn't support SQL queries) http://jackcess.sourceforge.net/faq.html#query
I'd recommend to use a Type 4 JDBC driver (i.e. full Java), more precisely the driver from HXTT (see this answer for some alternatives). Sadly, it's not an open source driver and it's not free. But if you are using Oracle, I think you can spend around 300 bucks for a driver.
Can you just use a JDBC-ODBC bridge for it. If you must do SQL, I've found that to be the best way.