\nYou already know how to do this. To be able to follow this lesson:
\nName the database LessonDB
\nCreate a table and Name it tblStudents
\nIn the table create four columns<\/p>\n
- \n
- ID<\/li>\n
- Firstname<\/li>\n
- Lastname<\/li>\n
- Department<\/li>\n<\/ul>\n
If you have done this correctly, your design view in MS Access would look like shown below:<\/p>\n
<\/p>\n
![](\"https:\/\/4.bp.blogspot.com\/-iriIcMuqNxg\/WifR8u-18AI\/AAAAAAAAAWw\/1t8TE7hlo4waSZ9slMnLsDz15PxnTfKqwCLcBGAs\/s320\/Connect-Netbeans-to-MS-Access-Design.JPG\")
<\/a><\/div>\n<\/p>\n
Add some random data into the table in Access. Say about 5 rows or more. We would be able to open and view this data in Netbeans
\nFor me after adding data to the tables, I have the content of the table as shown below:<\/p>\n<\/p>\n
![](\"https:\/\/3.bp.blogspot.com\/-UAickcPQ6A0\/WifSAV6eMzI\/AAAAAAAAAW0\/XRxDv4QC1Ig2MYfvc0SBDXIY0JoOTtcTQCLcBGAs\/s320\/Connect-Netbeans-to-MS-Access-Datasheet.JPG\")
<\/a><\/div>\n<\/p>\n
Step 2: Create an ODBC datasource<\/strong><\/p>\n
Go to Control Panel > Administrative Tools > ODBC Data Sources<\/p>\n
<\/p>\n
![](\"https:\/\/2.bp.blogspot.com\/-xjiG5kuwkTA\/WifSczK2kBI\/AAAAAAAAAW8\/i3PfOoc0M28bQG0EYcu_HcvZmKhyASGLgCLcBGAs\/s320\/Connect-Netbeans-to-MS-Access-ODBC-Data-Sources.JPG\")
<\/a><\/div>\n<\/p>\n
Click on System DSN.<\/p>\n
<\/p>\n
![](\"https:\/\/3.bp.blogspot.com\/-uP-hmET69H0\/WifTXT3-kMI\/AAAAAAAAAXM\/VWI4BgG24QQoJNCZ1IbTkxojHuWUBPregCLcBGAs\/s320\/Connect-Netbeans-to-MS-Access-ODBC-Data-Sources-System-DSN0.JPG\")
<\/a><\/div>\n<\/p>\n
Click on Add. It displays the Create New Data Source window<\/p>\n
<\/p>\n
![](\"https:\/\/4.bp.blogspot.com\/-qEB79fsNLUo\/WifS-lrtk9I\/AAAAAAAAAXI\/cryIPYzwXTkMXjuqBfrqO-0YvfTUG7AZQCLcBGAs\/s320\/Connect-Netbeans-to-MS-Access-ODBC-Data-Sources-System-DSN.JPG\")
<\/a><\/div>\n<\/p>\n
Choose Microsoft Access Driver(*.mdb, *.accdb).<\/p>\n
Click on Finish. Another window opens up<\/p>\n
Help!!!! I could not see any drivers listed!!!!<\/span>
\nThe reason for this is that your Operating System is 64 bit while the MS Access is 32 Bit.<\/p>\nSolution<\/span><\/span>
\nOpen the Windows Directory in your C drive and notice this two folders<\/p>\n<\/p>\n
![](\"https:\/\/2.bp.blogspot.com\/-1_P1iE7TfuA\/WifVCDA4rEI\/AAAAAAAAAXY\/uSDfcLW_dOwXR3tjoetzDj40vvSV7YCDQCLcBGAs\/s320\/Windows%2BDirectory.JPG\")
<\/a><\/div>\n<\/p>\n
Inside the they SysWOW64, you will find odbcad32. Open it and continue from there. Add a shortcut to it for easy access.<\/p>\n
<\/ins>
\nNow that you have solved that problem, let’s continue.<\/p>\n<\/p>\n
![](\"https:\/\/4.bp.blogspot.com\/-UQtFWmch7N0\/WifWC38OBRI\/AAAAAAAAAXk\/E53cTtWy33AMQSvFcLycbXhzmR9tf1EAwCLcBGAs\/s320\/Connect-Netbeans-to-MS-Access-Select%2BDatabase.JPG\")
<\/a><\/div>\n<\/p>\n
Click on Select, and find the MS Access database we created previously.<\/p>\n
<\/p>\n
![](\"https:\/\/2.bp.blogspot.com\/-qMRvVNuEf-c\/WifW_6YmRvI\/AAAAAAAAAXw\/swOgeXJ8k-oxwXaBWdvq7qpRVxJvQDl9ACLcBGAs\/s320\/Connect-Netbeans-to-MS-Access-Select%2BDatabase2.JPG\")
<\/a><\/div>\n<\/p>\n
Click on OK. This would take you back to the database selection window<\/p>\n
Enter a name for the database. For me I used same name LessonDB. (Make sure that MS Access application is closed, otherwise, you can’t complete it)<\/p>\n
Click on Ok to finish.<\/p>\n
<\/p>\n
![](\"https:\/\/4.bp.blogspot.com\/-iriIcMuqNxg\/WifR8u-18AI\/AAAAAAAAAWw\/1t8TE7hlo4waSZ9slMnLsDz15PxnTfKqwCLcBGAs\/s1600\/Connect-Netbeans-to-MS-Access-Design.JPG\")
<\/a><\/div>\n