Joe,
Thanks for your willingness to help me. Yes I can make a database within Access(I made one named COREJAVA). Here is the code to connect to the database. Actually, It's code from a book we are using for class.
public static Connection getConnection()
throws SQLException, IOException
{ Properties props = new Properties();
String fileName = "ViewDB.properties";
FileInputStream in = new FileInputStream(fileName);
props.load(in);
String drivers = props.getProperty("jdbc.drivers");
if (drivers != null)
System.setProperty("jdbc.drivers", drivers);
String url = props.getProperty("jdbc.url");
String username = props.getProperty("jdbc.username");
String password = props.getProperty("jdbc.password");
return
DriverManager.getConnection(url, username, password);
}
Here is the code in the ViewDB.properties file:
jdbc.drivers=sun.jdbc.odbc.JdbcOdbcDriver
jdbc.url=Jdbc:Odbc:COREJAVA
jdbc.username=PUBLIC
jdbc.password=PUBLIC
Any suggestions would be appreciated.
Clyde