aspose file tools*
The moose likes JDBC and the fly likes Microsoft Access DB Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of The Java EE 7 Tutorial Volume 1 or Volume 2 this week in the Java EE forum
or jQuery UI in Action in the JavaScript forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "Microsoft Access DB" Watch "Microsoft Access DB" New topic
Author

Microsoft Access DB

Ryan Sampson
Greenhorn

Joined: Jan 11, 2004
Posts: 12
if i use JDBC in my program to work with a microsoft acess database, it should work on every platform right?
Or am i wrong, and choosing a microsoft access database as my database limits me to only windows machines?
Bear Bibeault
Author and ninkuma
Marshal

Joined: Jan 10, 2002
Posts: 61063
    
  66

If you don't want to hobble yourself to the Redmond Way, I'd consider an alernate DB such as MySQL or PostgreSQL.


[Asking smart questions] [Bear's FrontMan] [About Bear] [Books by Bear]
David O'Meara
Rancher

Joined: Mar 06, 2001
Posts: 13459

or even hypersonic SQL for non-production scratch-work.
Ryan Sampson
Greenhorn

Joined: Jan 11, 2004
Posts: 12
so a microsoft access db is platform dependent? And if i use it in my program, people on unix or other non windows platforms will have problems?
Figured maybe it didnt matter what the platform was..
Bear Bibeault
Author and ninkuma
Marshal

Joined: Jan 10, 2002
Posts: 61063
    
  66

Depends what exactly you are talking about. If you have a server running on Windows accessing the Access DB, clients connecting to that server won't care. If you are connecting directly using JDBC, there are driver limitations that you will run up against (search this forum's history for details). If you want Access itself to run on anything other than Windows*, that's a complete NO GO.
Rumor has it that MS is preparing a version of Access for inclusion in the Mac OS X version of Office, but why bother when better DB's are available?
[ April 13, 2004: Message edited by: Bear Bibeault ]
 
With a little knowledge, a cast iron skillet is non-stick and lasts a lifetime.
 
subject: Microsoft Access DB