• 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:
  • Liutauras Vilda
  • Campbell Ritchie
  • Tim Cooke
  • Bear Bibeault
  • Devaka Cooray
Sheriffs:
  • Jeanne Boyarsky
  • Knute Snortum
  • Junilu Lacar
Saloon Keepers:
  • Tim Moores
  • Ganesh Patekar
  • Stephan van Hulst
  • Pete Letkeman
  • Carey Brown
Bartenders:
  • Tim Holloway
  • Ron McLeod
  • Vijitha Kumara

MS Access connection to Java code with GUI  RSS feed

 
Greenhorn
Posts: 1
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I have been tasked with making a login system for my college library. I have never written a program which would use a connection to an MS Access database (or any other database). Can someone Please help me out. I will give the helper due credit if that's what you would be concerned about. I know I shouldn't have taken up a job that I didn't know how to do, but can't help it now. Please help me out here. Thanks in advance.

This is what I found on YouTube, but I couldn't understand a thing:

 
Saloon Keeper
Posts: 4743
117
  • Likes 1
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
The first thing to note is that this code uses the JDBC/ODBC bridge (that's what "jdbc:odbc:" signifies") - that is no longer part of Java. So you can just forget about this entire example.

There are two other ways to access an Access DB that I know of. One is the JDBC driver from HXTT, which is commercial. Assuming your project has no budget, that would be ruled out.

The other is the Jackcess library. I've never used that, but the web site has various promising links such as Cookbook and FAQ which I guess should get you started.
 
Consider Paul's rocket mass heater.
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!