Win a copy of Clojure in Action this week in the Clojure forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

how can java connect to Access?

 
ken jun
Ranch Hand
Posts: 46
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 312
Java MS IE
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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.
 
ken jun
Ranch Hand
Posts: 46
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 312
Java MS IE
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 46
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic