Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!

Categories

Using Access DB for a Standalone application.

Dexter99Dexter99 Member Posts: 3
Hello guys,

I'm currently developing an assignment project that Schedules Jobs. It is a standalone application in Java. I want to use a DB to store the Schedules and update/access them from my application. Can I use access to build this small table? Will the application work on Systems that don't have Access installed. If not, then how do other commercial scheduler applications do it?

Thanks and Regards :)

Comments

  • bradwangbradwang Member Posts: 197
    : Hello guys,
    :
    : I'm currently developing an assignment project that Schedules Jobs.
    : It is a standalone application in Java. I want to use a DB to store
    : the Schedules and update/access them from my application. Can I use
    : access to build this small table? Will the application work on
    : Systems that don't have Access installed. If not, then how do other
    : commercial scheduler applications do it?
    :
    : Thanks and Regards :)
    :

    Hello, yeah, I believe you can surely use Access for the database purpose. However, why are you using Java, but not .NET or Delphi etc which are much simpler in building up such programs.

    Java seems to be ideal for building up large scale enterprise level solutions but not this kind of small applications. :)

    Just my 2 cents...

    I'm Brad Wang...
    .NET Freelancer from China
    MSN: brad_wang_cn@hotmail.com
    Skype: brad_wang
  • Dexter99Dexter99 Member Posts: 3
    : : Hello guys,
    : :
    : : I'm currently developing an assignment project that Schedules Jobs.
    : : It is a standalone application in Java. I want to use a DB to store
    : : the Schedules and update/access them from my application. Can I use
    : : access to build this small table? Will the application work on
    : : Systems that don't have Access installed. If not, then how do other
    : : commercial scheduler applications do it?
    : :
    : : Thanks and Regards :)
    : :
    :
    : Hello, yeah, I believe you can surely use Access for the database
    : purpose. However, why are you using Java, but not .NET or Delphi etc
    : which are much simpler in building up such programs.
    :
    : Java seems to be ideal for building up large scale enterprise level
    : solutions but not this kind of small applications. :)
    :
    : Just my 2 cents...
    :
    : I'm Brad Wang...
    : .NET Freelancer from China
    : MSN: brad_wang_cn@hotmail.com
    : Skype: brad_wang


    Thanks for the advice. But as I've said, this is an assignment project and hence working on Java was one of the constraints.

    So, I simply have to create a .mdb table, place it on the application folder and thats it?! I'm sorry if that was naive.. I'm new to programming.

    Thanks again.


  • bradwangbradwang Member Posts: 197
    : : : Hello guys,
    : : :
    : : : I'm currently developing an assignment project that Schedules Jobs.
    : : : It is a standalone application in Java. I want to use a DB to store
    : : : the Schedules and update/access them from my application. Can I use
    : : : access to build this small table? Will the application work on
    : : : Systems that don't have Access installed. If not, then how do other
    : : : commercial scheduler applications do it?
    : : :
    : : : Thanks and Regards :)
    : : :
    : :
    : : Hello, yeah, I believe you can surely use Access for the database
    : : purpose. However, why are you using Java, but not .NET or Delphi etc
    : : which are much simpler in building up such programs.
    : :
    : : Java seems to be ideal for building up large scale enterprise level
    : : solutions but not this kind of small applications. :)
    : :
    : : Just my 2 cents...
    : :
    : : I'm Brad Wang...
    : : .NET Freelancer from China
    : : MSN: brad_wang_cn@hotmail.com
    : : Skype: brad_wang
    :
    :
    : Thanks for the advice. But as I've said, this is an assignment
    : project and hence working on Java was one of the constraints.
    :
    : So, I simply have to create a .mdb table, place it on the
    : application folder and thats it?! I'm sorry if that was naive.. I'm
    : new to programming.
    :
    : Thanks again.
    :
    :
    :


    Hello, yeah, you need to create the Access db first, then create the tables you want inside the db. From your Java application, you need to connect to the Access db using JDBC or ODBC, here is an article on this:
    http://www.java2s.com/Tutorial/Java/0340__Database/ConnecttoAccessDatabaseusingJDBCODBCbridge.htm

    Sorry, I'm not experts on Java and don't know too much of the Java world, if you are posting questions on .NET, I think I can handle most of them. :)

    I'm Brad Wang...
    .NET Freelancer from China
    MSN: brad_wang_cn@hotmail.com
    Skype: brad_wang
  • Dexter99Dexter99 Member Posts: 3
    : : : : Hello guys,
    : : : :
    : : : : I'm currently developing an assignment project that Schedules Jobs.
    : : : : It is a standalone application in Java. I want to use a DB to store
    : : : : the Schedules and update/access them from my application. Can I use
    : : : : access to build this small table? Will the application work on
    : : : : Systems that don't have Access installed. If not, then how do other
    : : : : commercial scheduler applications do it?
    : : : :
    : : : : Thanks and Regards :)
    : : : :
    : : :
    : : : Hello, yeah, I believe you can surely use Access for the database
    : : : purpose. However, why are you using Java, but not .NET or Delphi etc
    : : : which are much simpler in building up such programs.
    : : :
    : : : Java seems to be ideal for building up large scale enterprise level
    : : : solutions but not this kind of small applications. :)
    : : :
    : : : Just my 2 cents...
    : : :
    : : : I'm Brad Wang...
    : : : .NET Freelancer from China
    : : : MSN: brad_wang_cn@hotmail.com
    : : : Skype: brad_wang
    : :
    : :
    : : Thanks for the advice. But as I've said, this is an assignment
    : : project and hence working on Java was one of the constraints.
    : :
    : : So, I simply have to create a .mdb table, place it on the
    : : application folder and thats it?! I'm sorry if that was naive.. I'm
    : : new to programming.
    : :
    : : Thanks again.
    : :
    : :
    : :
    :
    :
    : Hello, yeah, you need to create the Access db first, then create the
    : tables you want inside the db. From your Java application, you need
    : to connect to the Access db using JDBC or ODBC, here is an article
    : on this:
    : http://www.java2s.com/Tutorial/Java/0340__Database/ConnecttoAccessDat
    : abaseusingJDBCODBCbridge.htm
    :
    : Sorry, I'm not experts on Java and don't know too much of the Java
    : world, if you are posting questions on .NET, I think I can handle
    : most of them. :)
    :
    : I'm Brad Wang...
    : .NET Freelancer from China
    : MSN: brad_wang_cn@hotmail.com
    : Skype: brad_wang

    Thank you for that link. I've made a Web application before.. and have used Access database there. But that application was run inside the eclipse environment. Now I'm tryin to make a GUI application. Hence, was wondering about how the database part can be managed if the terminal that runs the application does not have Access installed. I googled for solutions before and came across the term "Access runtime" that needs to be installed before I could use this application elsewhere. Can you shed more light on that?

    Again, Thanks for your help. :)


  • bradwangbradwang Member Posts: 197
    : : : : : Hello guys,
    : : : : :
    : : : : : I'm currently developing an assignment project that Schedules Jobs.
    : : : : : It is a standalone application in Java. I want to use a DB to store
    : : : : : the Schedules and update/access them from my application. Can I use
    : : : : : access to build this small table? Will the application work on
    : : : : : Systems that don't have Access installed. If not, then how do other
    : : : : : commercial scheduler applications do it?
    : : : : :
    : : : : : Thanks and Regards :)
    : : : : :
    : : : :
    : : : : Hello, yeah, I believe you can surely use Access for the database
    : : : : purpose. However, why are you using Java, but not .NET or Delphi etc
    : : : : which are much simpler in building up such programs.
    : : : :
    : : : : Java seems to be ideal for building up large scale enterprise level
    : : : : solutions but not this kind of small applications. :)
    : : : :
    : : : : Just my 2 cents...
    : : : :
    : : : : I'm Brad Wang...
    : : : : .NET Freelancer from China
    : : : : MSN: brad_wang_cn@hotmail.com
    : : : : Skype: brad_wang
    : : :
    : : :
    : : : Thanks for the advice. But as I've said, this is an assignment
    : : : project and hence working on Java was one of the constraints.
    : : :
    : : : So, I simply have to create a .mdb table, place it on the
    : : : application folder and thats it?! I'm sorry if that was naive.. I'm
    : : : new to programming.
    : : :
    : : : Thanks again.
    : : :
    : : :
    : : :
    : :
    : :
    : : Hello, yeah, you need to create the Access db first, then create the
    : : tables you want inside the db. From your Java application, you need
    : : to connect to the Access db using JDBC or ODBC, here is an article
    : : on this:
    : : http://www.java2s.com/Tutorial/Java/0340__Database/ConnecttoAccessDat
    : : abaseusingJDBCODBCbridge.htm
    : :
    : : Sorry, I'm not experts on Java and don't know too much of the Java
    : : world, if you are posting questions on .NET, I think I can handle
    : : most of them. :)
    : :
    : : I'm Brad Wang...
    : : .NET Freelancer from China
    : : MSN: brad_wang_cn@hotmail.com
    : : Skype: brad_wang
    :
    : Thank you for that link. I've made a Web application before.. and
    : have used Access database there. But that application was run
    : inside the eclipse environment. Now I'm tryin to make a GUI
    : application. Hence, was wondering about how the database part can be
    : managed if the terminal that runs the application does not have
    : Access installed. I googled for solutions before and came across the
    : term "Access runtime" that needs to be installed before I could use
    : this application elsewhere. Can you shed more light on that?
    :
    : Again, Thanks for your help. :)
    :
    :
    :


    Yeah,I believe you need to have Access Runtime installed on the PC which is going to run the Java Application you wrote.

    I'm Brad Wang...
    .NET Freelancer from China
    MSN: brad_wang_cn@hotmail.com
    Skype: brad_wang
Sign In or Register to comment.