# HOW TO: connect to Microsoft Access using JDBC

**URL:** <https://forum.servoy.com/t/how-to-connect-to-microsoft-access-using-jdbc/12207>\
**Category:** Classic Servoy\
**Created:** [May 20, 2010, 10:46am UTC](https://forum.servoy.com/t/how-to-connect-to-microsoft-access-using-jdbc/12207 "2010-05-20T10:46:40Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![Jan\_Aleman](https://avatars.discourse-cdn.com/v4/letter/j/4af34b/32.png) [@Jan\_Aleman](https://forum.servoy.com/u/Jan_Aleman)\
**Post date:** [May 20, 2010, 10:46am UTC](https://forum.servoy.com/t/how-to-connect-to-microsoft-access-using-jdbc/12207/1 "2010-05-20T10:46:40Z")

</div>

1. Download the hxtt JDBC driver here [http://www.hxtt.com/access.html](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]

 ![Screen shot 2010-05-20 at 12.45.37 PM.png](https://canada1.discourse-cdn.com/flex010/uploads/servoy/original/2X/c/c806bc1366f772d6f73f289a5fb8b60ba8498872.png)

---

<div class="post-metadata">

**Author:** ![Siem](https://avatars.discourse-cdn.com/v4/letter/s/c89c15/32.png) [@Siem](https://forum.servoy.com/u/Siem)\
**Post date:** [May 21, 2010, 12:33pm UTC](https://forum.servoy.com/t/how-to-connect-to-microsoft-access-using-jdbc/12207/2 "2010-05-21T12:33:46Z")

</div>

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)

---

<div class="post-metadata">

**Author:** ![mwiedemann](https://avatars.discourse-cdn.com/v4/letter/m/5f8ce5/32.png) [@mwiedemann](https://forum.servoy.com/u/mwiedemann)\
**Post date:** [August 5, 2015, 5:08pm UTC](https://forum.servoy.com/t/how-to-connect-to-microsoft-access-using-jdbc/12207/3 "2015-08-05T17:08:53Z")

</div>

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]

 ![Picture.png](https://canada1.discourse-cdn.com/flex010/uploads/servoy/original/2X/3/32b3da7f0af778b63f363e9cb33d98682617d855.png)

---

<div class="post-metadata">

**Author:** ![mwiedemann](https://avatars.discourse-cdn.com/v4/letter/m/5f8ce5/32.png) [@mwiedemann](https://forum.servoy.com/u/mwiedemann)\
**Post date:** [August 7, 2015, 4:10pm UTC](https://forum.servoy.com/t/how-to-connect-to-microsoft-access-using-jdbc/12207/4 "2015-08-07T16:10:37Z")

</div>

Bump…

---

<div class="post-metadata">

**Author:** ![Jan\_Aleman](https://avatars.discourse-cdn.com/v4/letter/j/4af34b/32.png) [@Jan\_Aleman](https://forum.servoy.com/u/Jan_Aleman)\
**Post date:** [August 14, 2015, 10:37am UTC](https://forum.servoy.com/t/how-to-connect-to-microsoft-access-using-jdbc/12207/5 "2015-08-14T10:37:43Z")

</div>

what’s the detailed error?