wood burning stoves 2.0*
The moose likes JDBC and the fly likes how can java connect to Access? Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC
Bookmark "how can java connect to Access?" Watch "how can java connect to Access?" New topic
Author

how can java connect to Access?

ken jun
Ranch Hand

Joined: Apr 23, 2010
Posts: 46
I have installed Microsoft Office 2003 and it has Access . I want to make a program with java to alter the database(Access) . How could I do it? I have search the Internet that need the drivers which connect the java to the database but I can find no drivers about Access, I can merely find like MySql Oracle and so on....
Maybe someone can provide me a very simple code to alter the database, I will appreciate you if provide me a simple Access database file..haha ...

by the way, I know that if java need to connect to MySql that it need an URL which refer to the database server, is Access do the same thing? But it doesn't seems the Access 2003 like a server program.. So could anyone tell me whether alter the Access database just need to include a particular Access file ,what I means is that the Access database just build one(or some) particular file(s), the the JAVA just need to alter it without linking to an URL?

I am not confident with my expression so if you don't understand what I want to ask , I hope you can finger out that.

thank you
jun
Madhan Sundararajan Devaki
Ranch Hand

Joined: Mar 18, 2011
Posts: 312

MS-ACCESS is a product from MicroSoft.

All MicroSoft Databases can be accessed by creating a DSN

To access the MS-ACCESS database, please create a System DSN and use JDBC-ODBC method to use it in Java.


S.D. MADHAN
Not many get the right opportunity !
ken jun
Ranch Hand

Joined: Apr 23, 2010
Posts: 46
Madhan Sundararajan Devaki wrote:MS-ACCESS is a product from MicroSoft.

All MicroSoft Databases can be accessed by creating a DSN

To access the MS-ACCESS database, please create a System DSN and use JDBC-ODBC method to use it in Java.


Thank you I will search what is DSN and try it later ....just finish my supper..need to rest for a moment
Madhan Sundararajan Devaki
Ranch Hand

Joined: Mar 18, 2011
Posts: 312

One more thing you need to remember, is that MS-ACCESS has its own extensions in addition to the standard ANSI SQL, hence, some DML statements may not work. For example, alter database, etc... Please check MicroSoft site for additional official information on this.
ken jun
Ranch Hand

Joined: Apr 23, 2010
Posts: 46
Madhan Sundararajan Devaki wrote:One more thing you need to remember, is that MS-ACCESS has its own extensions in addition to the standard ANSI SQL, hence, some DML statements may not work. For example, alter database, etc... Please check MicroSoft site for additional official information on this.


thanks for reminding me
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: how can java connect to Access?