Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
String url= "jdbcdbcriver={Microsoft Access Driver (*.mdb)};DBQ=C:/temp/thebase.mdb";
String user = "user";
String pass = "pass";
Connection connection = DriverManager.getConnection(url,user,pass);

// if i use above what user/pass to use ? default is root/root or ? db come with textbook files ...

MySQL DSNs & Access DSNs must have different names in a PC system ?

I don't know if the system prevents you to define two DSN with the same name, but it's certainly at least confusing. How could application get the right one, if they have the same name ?
If you mean you've already created two DSN with the same name, maybe you're accessing MySQL database and that's why you don't see anything in Access !

Laurent

finally I found error, there was two files WINESDB.mdb in hdd... I try both connection ways success, well to make a distributed App Java database[TYPE 1] desktop standalone I need absolutelly an IDE(GUI) ? CLI used only javac & java commands ?

Yes, I suspected something of the like.
Sorry, I don't understand the question.
Well, you have a program which fills a database (desktop or not). Then what do you want to do with this database ?

Laurent

Java desktop Apps that use database[Access .mdb _ TYPE 1] (standalone) that are .exe files for windows how are created ?

I need absolutelly an IDE(GUI) ? CLI used only javac & java commands ?

I don't clearly understand what you want to do.
Java apps are not .exe files. Most often, they are shipped in a .jar file. The jar.exe command line application can create them.
You don't need an IDE to create a Java app, but you probably better should use one. NetBeans for instance is free and comes with Java jdk. It provides a standalone Java SQL database too (Derby).

Laurent

well, this I want is from files.java/files.class make a stand alone App(with Access propably) that a user can install in his PC with a desktop access icon, and user non have MS-Access, JDK, JRE ... app be stand alone ...well .jar files is like zip ?

You should read more about Java and Java developpment. These are basics and you will learn faster than asking here.
BTW, Java JRE is mandatory, but comes with many systems. When installed, .jar files can be run by double click.

Laurent

To help your users to install your java application you could use any of the existing java installers. Search for "java installers" or similar. But the first step however should be, as Pyrophorus said, to read a bit more on general java topics. Just dont get frightened if you find this whole thing about jar and class-files confusing, you just have to be familiar with the concept.