Click here to Skip to main content
15,569,774 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
Hi,
I was hoping someone could help me. In the past, I wrote desktop applications using Visual Basic. The applications were standalone that read MDB database files not connected to a server or DB management system. The database files could be browsed and modified outside of my application using MS Access and other DB management software that processing MDB files.

Is there something similar for JAVA. I am using NetBeans, Derby (but could use some other DB). This is what I want to do. Where can I find more info. maybe a website, Youtube vid, etc.

- Develop desktop applications using JAVA. I prefer Netbeans for my IDE. (Eclipse is also an option).
- Create a database and tables using a DB management system.
- The database is a standalone file that could be used with the desktop application.
- The desktop application written in Java can process the database contained within the standalone file. for example, something like *.MDB.
- The database could be manipulated, maybe add a new column after the program is using it, using a DB management system.

BTW, I have used embedded databases with my JAVA programs. That is good except how could I read the database into a DB Management system to add a column for example?

Any info is appreciated.
Thanks,
Steve

What I have tried:

I have used embedded databases with my JAVA programs. That is good except how could I read the database into a DB Management system to add a column for example?
Posted
Comments
Mohibur Rashid 19-Oct-17 17:27pm    
Msaccess is still an option, you can look up sqlite
Member 13387568 19-Oct-17 20:55pm    
Hi Rashid,
I got it to work with a JAVA program accessing a MDB file using the ucanaccess jdbc jar files. Have you heard of that. Has anyone heard of that approach? I am only using this for my own personal use. Thank you, Steven
Mohibur Rashid 19-Oct-17 21:35pm    
I never used UCanAccess; if it feeds your needs then why not?
And of course google is your friend, look for JDBC for MDB, you will get many answers. And if you want portability, I don't know whether you can use MDB in other os or not, then SQLite3 will not be bad. FYI, many applications, such as google chrome, use SQLite3;

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900