Re: Has anyone connected to an MS Access database

[Alan Campin <alan0307d@xxxxxxxxx>]

You need a Type 4 JDBC driver. You need to know if you can access Access
with a JDBC type 4 driver.

Found this.

http://ucanaccess.sourceforge.net/site.html


On Mon, Jan 29, 2018 at 9:31 AM, Jay Triche <JTriche@xxxxxxxxxxxxx> wrote:

> Hello all,
>
> I'm posting to the Java group since I suspect JDBC or a combination of
> JDBC & ODBC would be the preferred method for connecting to a MS Access
> database from RPG.
> We are currently using Scott Klement's JDBCR4 routines to access MS SQL
> and Oracle databases.
> I've scan the Java list for the past 4 years and 'Haven't seen any mention
> of MS Access.
> Does anyone know how to access a Microsoft Access database from the IBM i?
>
> We're on 7.1 and actively planning our move to 7.3.  We're in the process
> of updating to Java 8.  I think our production system is still Java 6.
>
> Thanks,
> Jay Triche
> Senior Programmer/Analyst
> Lamps Plus
> --
> This is the Java Programming on and around the IBM i (JAVA400-L) mailing
> list
> To post a message email: JAVA400-L@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: https://lists.midrange.com/mailman/listinfo/java400-l
> or email: JAVA400-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at https://archive.midrange.com/java400-l.