Page 1 of 1

HOW TO: connect to Microsoft Access using JDBC

PostPosted: Thu May 20, 2010 12:46 pm
by Jan Aleman
1. Download the hxtt JDBC driver here http://www.hxtt.com/access.html
2. Extract the ZIP file, inside it in the lib directory you will find Access_JDBC30.jar copy that file into the drivers directory inside your application_server directory of your Servoy folder
3. (Re)-start Servoy developer
4. Right Click on Database Servers, choose New --> Empty and fill in the following:
Server Name: whatever you wish to name the connection
URL: jdbc:access://PATHTOMDBFILE
Driver: com.hxtt.sql.access.AccessDriver

Thats it. Save and you are ready to use it.
Some URL examples:

"jdbc:access:/."
"jdbc:access:/c:/data" for Windows driver
"jdbc:access:///c:/data" for Windows driver
"jdbc:access:////usr/data" for unix or linux
"jdbc:access://///192.168.10.2/sharedir" for UNC path
"jdbc:access:/./data"
"jdbc:access:/./data/mydata.mdb"
Screen shot 2010-05-20 at 12.45.37 PM.png
Screen shot 2010-05-20 at 12.45.37 PM.png (48.51 KiB) Viewed 9412 times

Re: HOW TO: connect to Microsoft Access using JDBC

PostPosted: Fri May 21, 2010 2:33 pm
by Siem
UP and RUNNING !

Thanks Jan! Now I'm browsing through my linked Access tables, field and query's with Servoy on one computer while in my old MS Access environment on the other.

Now I can start playing around with rebuilding some forms.

Best regards,
Siem

PS the trial of this HXTT driver is free, but limited to 50 records. You need to buy this driver for at least US$ 361,-- (Single Server License: unlimited connections, for a single server)

Re: HOW TO: connect to Microsoft Access using JDBC

PostPosted: Wed Aug 05, 2015 7:08 pm
by mwiedemann
I have a user that insists on using an Access database as part of a larger solution. So, I have installed the hxtt Access driver and followed the instructions as laid out by Jan but am getting an error when I attempt to save my database connection.

Any ideas??

Thanks much!
Martin

Picture.png
Picture.png (26.92 KiB) Viewed 8205 times

Re: HOW TO: connect to Microsoft Access using JDBC

PostPosted: Fri Aug 07, 2015 6:10 pm
by mwiedemann
Bump....

Re: HOW TO: connect to Microsoft Access using JDBC

PostPosted: Fri Aug 14, 2015 12:37 pm
by Jan Aleman
what's the detailed error?