File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/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 Murach's Java Servlets and JSP this week in the Servlets 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: 60765
    
  65

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: 60765
    
  65

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 ]
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Microsoft Access DB
 
Similar Threads
a servlet which have to access Microsoft access
Dumb question, any visual database management tool?
jdbc connection to ms sql (urgent)
Connecting to Access
Too Many Client Tasks