How can I do when getting connection to an mdb file which needs Service Name, User Name and Password?

[KnightBlade Chen]

I know how to get connection to an mdb file like below:
Connection conn=DriverManager.getConnection("jdbc:ucanaccess://<you mdb="" path="">");

But if it needs Service Name, User Name and Password like the picture:
http://imgur.com/a/R61yX

What additional parameter or codes will be added in?

[Gord Thompson]

It looks like the Access database contains one or more ODBC linked tables that reside on an Oracle server. If so, then UCanAccess cannot work with the linked table(s) because UCanAccess does not use ODBC. (It directly manipulates native Access tables via Jackcess.)

If you need to work with native Access tables and ODBC linked tables simultaneously (e.g., SELECT ... FROM AccessTable INNER JOIN OracleTable) then I'd suggest that you use C# on Windows with System.Data.Odbc and the appropriate ODBC drivers (Access and Oracle).

[KnightBlade Chen]

Thank you very much! I really need to link tables and update data in real-time. I'll try to use C#.