Access is for desktop or web Apps BUT MySQL is ONLY for web Apps ?
May Java desktop Apps use MySQL...If yes, how much space take the database structure in the App, if for example data in database reach 1MB exactly...?

MySQL is a database server, and is appropriate for any type of database application.

mysql is appropriate even for offline, windows desktop apps [eg. JAVA]?

mysql is a database server its suitable for virtually any application (web, desktop, corporate or whatever) usage

however it does have some limitations, especially in the secuirty model.
like all db products it depends on what version you use V5 is a better than V4 and there can be significant differences between builds of the same version.

its not as sophisticated or rounded as other server db's.

ultimately it depends on what you want to do, how you want to interact with the db. what your budget is what your knowledge is.

the number of people working as MySQL DBA's is a far smaller pool than other db's, so that could be a problem
its support for stored procedures / triggers is not as sophisticated as others.
it can be blisteringly fast at retrieving data.

Wouldn't you do better using a RDBMs that's actually designed to run within applications ie something like SQLITE.

Maybe he wants a bona-fide SERVER....

It's difficult to tell what he really wants - the question marks seem to appear as random punctuation but perhaps if he tells us what he's trying to do then we can offer better suggestions :

• Is it a stand alone application or a web based application?
• Do you want a database that multiple users can talk to?
• Do you want a database that just one instance of an application can talk to?
• Are you using Java for the application?
• Why is space so important?
• Are you looking for any special database features?

stand alone application
one user or network app multiple users
one instance of app or many^
yes JAVA or VB
this is my first app , so I ask about space
no just do simple db jobs

I think you're looking for an embedded db (e.g. derby or hsqld for java)

I thin it depends entirely on the eventual use of the app
an embedded db may be the smart choice, a server db may be a smart choice. the smarted choice may be to build support fo ras many db's as required and implement them through composition classes

Access is embedded db ?