HOW TO: connect to Microsoft Access using JDBC

[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”
[attachment=0]Screen shot 2010-05-20 at 12.45.37 PM.png[/attachment]

[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)

[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

[attachment=0]Picture.png[/attachment]

[mwiedemann]

Bump…

[Jan_Aleman]

what’s the detailed error?