Creting an ODBC Connection with Access database


1.From Control Panel, Select Administrative tool
2.Then from Administrative tool select Data Sources
3.From the System DSN tab click ADD
4.Select Microsoft Access Driver (*.mdb) //if you are using latter versions of Access
5.Set the name of your data source name: as student_odbc
6. click select to select the access database
7. then click OK (now you have created your ODBC system DSN)