How to configure access from java program to MS ACCESS database on DeAnza lab computer. In summary: Create database file, configure logical data source to it. You have to create the database only once, but you have to configure the logical data source every time you log in. Details below: Do these first five steps to set up the database initially, but again every time you log in again: 1. Go to Start Menu, select settings, and then select 'Control Panel'. 2. Select 'Administrative Tools'. 3. Select 'DataSources (ODBC)'. 4. You should be already in the 'User DSN' page, press 'ADD' button. 5. In that window Double click on the 'Microsoft Access Driver'. (I) If you are creating the database for the first time, follow the steps below. Do the first 1 to 5 steps above before proceeding further. i. Click on 'CREATE' button. ii. Select the Directory. iii. Type the Database Name. iv. Click 'OK'. v. We get a window saying that the Database is created successfully, click 'OK'. vi. Type the 'DataSource Name' and 'Description'. vii. Click 'OK'. viii.Click 'OK'. Creating the Table to access from the java file. Go to the Windows desktop: a. Go to the location where you have created the "xxxx.mdb" file and Double Click on it. b. Select 'Create table by using wizard'. c. Proceed further with the wizard and create a table of your own with the fields. d. Open the created table and enter some appropriate values in the fields. (Any time later you can double click on that database-file again to add more data etc.) (II) For later LOGINs, follow the steps below. Do the first 1 to 5 steps above before proceeding further. i. Click on 'SELECT' button. ii. Select the Directory where the 'xxxx.mdb' is residing. iii. Double click on the 'xxxx.mdb' file Name. iv. Type the 'DataSource Name' and 'Description'. v. Click 'OK'. vi. Click 'OK'. Regardless of whether this is first time or later login, you can now run your java program to connect to the database etc.