{"id":239,"date":"2017-12-07T15:31:00","date_gmt":"2017-12-07T15:31:00","guid":{"rendered":"https:\/\/kindsonthegenius.com\/blog\/2017\/12\/07\/connecting-netbeans-to-ms-access-resolved-problems\/"},"modified":"2020-08-22T21:00:16","modified_gmt":"2020-08-22T19:00:16","slug":"connecting-netbeans-to-ms-access-resolved-problems","status":"publish","type":"post","link":"https:\/\/kindsonthegenius.com\/blog\/connecting-netbeans-to-ms-access-resolved-problems\/","title":{"rendered":"Connecting Netbeans to MS Access &#8211; Resolved Problems"},"content":{"rendered":"<div style=\"color: #555555; font-size: 18px; line-height: 30px; text-align: justify;\">\n<div style=\"font-family: 'segoe ui';\">\n<p>In this blog, I am going to address some of the typical problems encountered by\u00a0 programmers who try to connect Netbeans to the MS Access Database.<\/p>\n<div style=\"clear: both; text-align: center;\"><a style=\"margin-left: 1em; margin-right: 1em;\" href=\"https:\/\/2.bp.blogspot.com\/-66BbLmzkt6Y\/WilrOTFoFUI\/AAAAAAAAAZk\/oSksPuDueV42uxU3fbrLsmn32anvojxgwCLcBGAs\/s1600\/Missing-JDBC-ODBC-Resolved.jpg\"><img decoding=\"async\" loading=\"lazy\" src=\"https:\/\/2.bp.blogspot.com\/-66BbLmzkt6Y\/WilrOTFoFUI\/AAAAAAAAAZk\/oSksPuDueV42uxU3fbrLsmn32anvojxgwCLcBGAs\/s320\/Missing-JDBC-ODBC-Resolved.jpg\" width=\"320\" height=\"234\" border=\"0\" data-original-height=\"1109\" data-original-width=\"1512\" \/><\/a><\/div>\n<p>Since I traveled to Hungary for my Research, I have not responded to your comments for some time, but now I&#8217;m fully back to work since I have stabilized a bit in Budapest after suffering some jet lag.<\/p>\n<p>Take a look at the comments below<\/p>\n<div style=\"clear: both; text-align: center;\"><\/div>\n<div style=\"clear: both; text-align: center;\"><\/div>\n<div style=\"clear: both; text-align: center;\"><a style=\"margin-left: 1em; margin-right: 1em;\" href=\"https:\/\/3.bp.blogspot.com\/-oGew4wNRd-U\/WilbtLsG5KI\/AAAAAAAAAY4\/yKdxEkr3VQ03E8iSabqpSYF5XL3zbBEuwCLcBGAs\/s1600\/First.JPG\"><img decoding=\"async\" loading=\"lazy\" src=\"https:\/\/3.bp.blogspot.com\/-oGew4wNRd-U\/WilbtLsG5KI\/AAAAAAAAAY4\/yKdxEkr3VQ03E8iSabqpSYF5XL3zbBEuwCLcBGAs\/s640\/First.JPG\" width=\"640\" height=\"395\" border=\"0\" data-original-height=\"437\" data-original-width=\"703\" \/><\/a><\/div>\n<p>&nbsp;<\/p>\n<div style=\"clear: both; text-align: center;\"><a style=\"margin-left: 1em; margin-right: 1em;\" href=\"https:\/\/3.bp.blogspot.com\/-Stgilg0HzdY\/Wilbtpw8EyI\/AAAAAAAAAZA\/OwMpbfIypiIMS8IMjZd8IYNIxQBngWO7ACLcBGAs\/s1600\/Fourth.JPG\"><img decoding=\"async\" loading=\"lazy\" src=\"https:\/\/3.bp.blogspot.com\/-Stgilg0HzdY\/Wilbtpw8EyI\/AAAAAAAAAZA\/OwMpbfIypiIMS8IMjZd8IYNIxQBngWO7ACLcBGAs\/s640\/Fourth.JPG\" width=\"640\" height=\"331\" border=\"0\" data-original-height=\"574\" data-original-width=\"1108\" \/><\/a><\/div>\n<p>&nbsp;<\/p>\n<div style=\"clear: both; text-align: center;\"><a style=\"margin-left: 1em; margin-right: 1em;\" href=\"https:\/\/3.bp.blogspot.com\/-F4O12t_0pks\/WilbtVdLk4I\/AAAAAAAAAY8\/iIe_reTc0XAbWraOCWaCUWfvt5_BJCZ6wCLcBGAs\/s1600\/Second.JPG\"><img decoding=\"async\" loading=\"lazy\" src=\"https:\/\/3.bp.blogspot.com\/-F4O12t_0pks\/WilbtVdLk4I\/AAAAAAAAAY8\/iIe_reTc0XAbWraOCWaCUWfvt5_BJCZ6wCLcBGAs\/s640\/Second.JPG\" width=\"640\" height=\"425\" border=\"0\" data-original-height=\"551\" data-original-width=\"825\" \/><\/a><\/div>\n<p>&nbsp;<\/p>\n<div style=\"clear: both; text-align: center;\"><a style=\"margin-left: 1em; margin-right: 1em;\" href=\"https:\/\/2.bp.blogspot.com\/-3MmMmdvi2P8\/WilbuWce1aI\/AAAAAAAAAZE\/Lkx2ycSxtjITmcXUckNmW0Mr7XqV9_8ZACLcBGAs\/s1600\/Third.JPG\"><img decoding=\"async\" loading=\"lazy\" src=\"https:\/\/2.bp.blogspot.com\/-3MmMmdvi2P8\/WilbuWce1aI\/AAAAAAAAAZE\/Lkx2ycSxtjITmcXUckNmW0Mr7XqV9_8ZACLcBGAs\/s640\/Third.JPG\" width=\"640\" height=\"232\" border=\"0\" data-original-height=\"316\" data-original-width=\"869\" \/><\/a><\/div>\n<p>From the list of comments, you could see that the key question is:<\/p>\n<ul>\n<li>Missing JDBC-ODBC Bridge in Netbeans<\/li>\n<li>JDBC-ODBC driver not available in Netbeans<\/li>\n<\/ul>\n<p>Other issues include:<\/p>\n<ul>\n<li>There is nothing under databases in Java &#8211; Parth Mistry<\/li>\n<li>Can you explain how to access MS Access using UcanAccess &#8211; Ahmed Moh<\/li>\n<li>Unable to create the Datasource<\/li>\n<li>Could you make a video on how to Add, Edit, Delete and Modify Data &#8211; Uday Kumah<\/li>\n<\/ul>\n<p><b>Lest start from the first one &#8211; Missing JDBC-ODBC Driver<\/b><\/p>\n<p><b>Cause of the Problem<\/b><br \/>\nThe problem arises because Java stopped providing the JDBC-ODBC bridge as from Java 8. This means that\u00a0 is you are using Netbeans 8.x, then you would not be able to access the driver.<\/p>\n<p><b>Solution 1 (recommended)<\/b><br \/>\n<b>Install Netbeans 7.x. <\/b>This is the easiest way to resolve this issue. For the tutorials we are working with and for fairly large project, you could use Netbeans 7.x. Remember,\u00a0 that means you would also install <a href=\"http:\/\/www.oracle.com\/technetwork\/java\/javase\/downloads\/java-archive-downloads-javase7-521261.html\">jdk-7<\/a> which you can get from <a href=\"http:\/\/www.oracle.com\/technetwork\/java\/javase\/downloads\/java-archive-downloads-javase7-521261.html\">here<\/a>.<br \/>\nNote that you could still recieve updates and new plugins for Netbeans 7.x.<br \/>\nFor me, I have both installations in my system and both are working perfectly.<\/p>\n<p><b>Solution 2 (Buy a Connector)<\/b><br \/>\nYou could actually buy an JDBC-ODBC connector for Netbeans 8.x. I have tried to check if i could find a free one but I have not found. There is one from EasySoft you can buy or try out for two weeks. You can find it <a href=\"https:\/\/www.easysoft.com\/products\/data_access\/jdbc_odbc_bridge\/#section=tab-1\">here<\/a>.<\/p>\n<p><b>Unable to Create Datasource in Windows &#8211; MS Access Driver Not found<\/b><br \/>\nIf you go to Administrative Tools &gt; ODBC Data sources and click on the System DSN tab. You could create a new datasource by clicking the Add button. This would display the window below:<\/p>\n<div style=\"clear: both; text-align: center;\"><a style=\"margin-left: 1em; margin-right: 1em;\" href=\"https:\/\/2.bp.blogspot.com\/-ZCPLXr0nx2M\/WilnKSUVIjI\/AAAAAAAAAZY\/nAM22wJJGls1J7z33QwxKoA1iS17_ensgCLcBGAs\/s1600\/Connect-Netbeans-to-MS-Access-ODBC-Data-Sources-System-DSN.JPG\"><img decoding=\"async\" loading=\"lazy\" src=\"https:\/\/2.bp.blogspot.com\/-ZCPLXr0nx2M\/WilnKSUVIjI\/AAAAAAAAAZY\/nAM22wJJGls1J7z33QwxKoA1iS17_ensgCLcBGAs\/s320\/Connect-Netbeans-to-MS-Access-ODBC-Data-Sources-System-DSN.JPG\" width=\"320\" height=\"239\" border=\"0\" data-original-height=\"358\" data-original-width=\"478\" \/><\/a><\/div>\n<p>You can see a list of drivers.<br \/>\nHowever, if in your system, it shows blank. Then it means that there is a mismatch between the MS office\u00a0 and your operating system. One is 32bit and the other is 64 or vice versa.<\/p>\n<p><b>Solution<\/b><br \/>\nGo to the windows folder in your drive C and locate the two folders:<\/p>\n<ul>\n<li>System32<\/li>\n<li>SysWOW64<\/li>\n<\/ul>\n<p>Inside each, there is odbcad32. You can open it and use it to create your datasource. If it works, then you can add a shortcut to your desktop so you can always use it<\/p>\n<p>I hope this brief explanation solves the issues. If there are any more issues, you can leave a comment below.<br \/>\nI made this easy tutorial: <a href=\"https:\/\/youtu.be\/4WvtxU4oPtI\">How to Build a Calculator in Java Using Netbeans.<\/a> You can easily follow it.<\/p>\n<p>Thanks and have a nice day.<\/p>\n<p>&nbsp;<\/p>\n<\/div>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<p>In this blog, I am going to address some of the typical problems encountered by\u00a0 programmers who try to connect Netbeans to the MS Access &hellip; <\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_mi_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0},"categories":[414],"tags":[],"_links":{"self":[{"href":"https:\/\/kindsonthegenius.com\/blog\/wp-json\/wp\/v2\/posts\/239"}],"collection":[{"href":"https:\/\/kindsonthegenius.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/kindsonthegenius.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/kindsonthegenius.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/kindsonthegenius.com\/blog\/wp-json\/wp\/v2\/comments?post=239"}],"version-history":[{"count":1,"href":"https:\/\/kindsonthegenius.com\/blog\/wp-json\/wp\/v2\/posts\/239\/revisions"}],"predecessor-version":[{"id":1541,"href":"https:\/\/kindsonthegenius.com\/blog\/wp-json\/wp\/v2\/posts\/239\/revisions\/1541"}],"wp:attachment":[{"href":"https:\/\/kindsonthegenius.com\/blog\/wp-json\/wp\/v2\/media?parent=239"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/kindsonthegenius.com\/blog\/wp-json\/wp\/v2\/categories?post=239"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/kindsonthegenius.com\/blog\/wp-json\/wp\/v2\/tags?post=239"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}