Connecting UCanAccess to a database on a network share

Asked Oct 04 '15 at 16:18

Active Oct 04 '15 at 17:09

Viewed 581 times

I have to make a LAN-based app, but I'm having trouble with connecting my database to my Java project. When I tried this

public static void databaseCon(String connection) {
    try{
        Class.forName("net.ucanaccess.jdbc.UcanaccessDriver");
        dbConn = DriverManager.getConnection("jdbc:ucanaccess:\\\\KIM-PC\\share\\FPAS.accdb");            
    }
        catch(SQLException e){
            JOptionPane.showMessageDialog(null,e);
    }
}

the error message that I'm getting is

no suitable driver found for...

What should I do?

edited Oct 04 '15 at 17:09

Gord Thompson

116,920
32
215
418

asked Oct 04 '15 at 16:18

bloomindindin

1

Possible duplicate of [Unable to connect to a database on a shared drive - UCanAccess](http://stackoverflow.com/questions/31814796/unable-to-connect-to-a-database-on-a-shared-drive-ucanaccess) – RealSkeptic Oct 04 '15 at 16:29
Try using forward slashes (/) instead of backslashes (\\) in your connection URL: `jdbc:ucanaccess:////KIM-PC/share/FPAS.accdb` – Gord Thompson Oct 04 '15 at 16:35
thanks for the suggestions.. but It didnt work IDK why? – bloomindindin Oct 04 '15 at 16:38
Try commenting out the `Class.forName` statement. Chances are good that you don't need it. – Gord Thompson Oct 04 '15 at 16:51

Connecting UCanAccess to a database on a network share

0 Answers0