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

Trying to access to Microsoft Access from my java program.  RSS feed

 
Rudy Rusli
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.
 
Jeff Storey
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 ]
 
Ilja Preuss
author
Sheriff
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.
 
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!