Creating A Database
Step 1: start->all programs->Microsoft office->Microsoft office access 2007->click blank database->give filename to the database(right side)->create.
Once MS access is opened follow the steps:
Step 2:right click on Table1:Table(left side)->design view->(enter necessary details related to your prgm(field name and data type))->save(save the file in c or d drive)->close.
JDBC CONNECTION
Step1
tart->controlpanel->adminstrative tools->datasources(ODBC)->Databse1(databasename)->add->MicrosoftAccesDriver(*.mdb,*.accdb)->finish->
enter data source name(give the same name which you gave while creating the database)->select(select the file from the given path)->ok.
Note: After the completion of creation change the database name in the program.
Step 1: start->all programs->Microsoft office->Microsoft office access 2007->click blank database->give filename to the database(right side)->create.
Once MS access is opened follow the steps:
Step 2:right click on Table1:Table(left side)->design view->(enter necessary details related to your prgm(field name and data type))->save(save the file in c or d drive)->close.
JDBC CONNECTION
Step1
tart->controlpanel->adminstrative tools->datasources(ODBC)->Databse1(databasename)->add->MicrosoftAccesDriver(*.mdb,*.accdb)->finish->enter data source name(give the same name which you gave while creating the database)->select(select the file from the given path)->ok.
Note: After the completion of creation change the database name in the program.
Share your Study Materials with us : 