• 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
  • Liutauras Vilda
  • Jeanne Boyarsky
  • Devaka Cooray
  • Paul Clapham
Sheriffs:
  • Tim Cooke
  • Knute Snortum
  • Bear Bibeault
Saloon Keepers:
  • Ron McLeod
  • Tim Moores
  • Stephan van Hulst
  • Piet Souris
  • Ganesh Patekar
Bartenders:
  • Frits Walraven
  • Carey Brown
  • Tim Holloway

Trying to access to Microsoft Access from my java program.

 
Ranch Hand
Posts: 114
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
How do I access Microsoft Access from my java program?

I have jdk 1.4.2_08, is there any jar files included already that I haven't noticed?

Thanks in advance for all the help.
 
Ranch Hand
Posts: 118
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi Rudy,

Are you trying to embed MS Access into your application and provide access the user interface? If this is the case, you may not be able to do that.

But, if you are trying to access an MS Access database and not the whole program itself, you should be able to. You should try something like this:



Hope this helps.

IMPORTANT NOTE: IN THE DB_URL_PREFIX, REPLACE THE $ WITH :
I HAD TO DO THIS BECAUSE THE : WAS RESULTING IN THE GRAEMLINES APPEARING

Jeff

[ January 25, 2007: Message edited by: Jeff Storey ]

[ January 25, 2007: Message edited by: Jeff Storey ]
[ January 26, 2007: Message edited by: Jeff Storey ]
 
author
Posts: 14112
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator

Originally posted by Jeff Storey:

IMPORTANT NOTE: IN THE DB_URL_PREFIX, REPLACE THE $ WITH :
I HAD TO DO THIS BECAUSE THE : WAS RESULTING IN THE GRAEMLINES APPEARING



When you post a message, there is checkbox for disabling graemlins - "Disable smilies in this post."

 
Jeff Storey
Ranch Hand
Posts: 118
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator

Originally posted by Ilja Preuss:


When you post a message, there is checkbox for disabling graemlins - "Disable smilies in this post."



Thank you! I have edited my original post to include the
 
Rudy Rusli
Ranch Hand
Posts: 114
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I did this below, it didn't reach "C", it gave me the exception message "[Microsoft][ODBC Microsoft Access Driver] Could not find file '(unknown)'.":



[fbr - turned off smilies in message]
[ January 26, 2007: Message edited by: Fred Rosenberger ]
 
Rudy Rusli
Ranch Hand
Posts: 114
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Thanks for the help =)
It works now.
 
Consider Paul's rocket mass heater.
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!