This week's book giveaway is in the Java in General forum.
We're giving away four copies of Event Streams in Action and have Alexander Dean & Valentin Crettaz on-line!
See this thread for details.
Win a copy of Event Streams in Action this week in the Java in General forum!
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Devaka Cooray
  • Liutauras Vilda
  • Jeanne Boyarsky
  • Bear Bibeault
Sheriffs:
  • Paul Clapham
  • Knute Snortum
  • Rob Spoor
Saloon Keepers:
  • Tim Moores
  • Ron McLeod
  • Piet Souris
  • Stephan van Hulst
  • Carey Brown
Bartenders:
  • Tim Holloway
  • Frits Walraven
  • Ganesh Patekar

how can java connect to Access?

 
Ranch Hand
Posts: 46
  • 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
 
Ranch Hand
Posts: 312
MS IE Java
  • 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
  • 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
MS IE Java
  • 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
  • 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
 
With a little knowledge, a cast iron skillet is non-stick and lasts a lifetime.
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!