Search code examples
javadatabasems-accessjdbclan

How do I connect to an Access database over a LAN using Java?


Do you know of any good guides on how to access an Access database using Java?

I know the basics and basic SQL, but I'm thinking more about access control.


Solution

  • private static final String accessDBURLPrefix = "jdbc:odbc:Driver={Microsoft Access Driver (*.mdb)};DBQ=";
        private static final String accessDBURLSuffix = ";DriverID=22;READONLY=false}";
    
        // Initialize the JdbcOdbc Bridge Driver
        static {
            try {
                Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
            } catch(ClassNotFoundException e) {
                System.err.println("JdbcOdbc Bridge Driver not found!");
            }
        }
    
        /** Creates a Connection to a Access Database */
        public static Connection getAccessDBConnection(String filename) throws SQLException {
            filename = filename.replace('', '/').trim();
            String databaseURL = accessDBURLPrefix + filename + accessDBURLSuffix;
            return DriverManager.getConnection(databaseURL, "", "");
        }  
    

    Some useful links: