Best language to use for database program

Posted on 2012-09-18
Last Modified: 2012-10-04

I have developed a few small databases in MS Access 2003, but am always concerned that the computer I run them on will have to have Access installed. So I was wondering what you guys would recommend as a route to develop a database - I am still learning, so happy to try any language/method that is best. I already have VS2008 Pro, so not sure if there is something in there that will be suitable. I know the data part will need to be in something different, but not sure what. So help with the best combination of front end dev tool and back end data file is greatly appreciated.

Thanx in advance.
Question by:Ian Leason
    LVL 30

    Expert Comment

    Back End can be the database in access and select Front End as any of Visual studio's languages, VB, ... .
    Just decide which language to use, check documentation and ask for help when required.
    LVL 13

    Expert Comment

    What hnasr proposed is a good start. You can choose the Visual Studio language based on your background.
    Say, if your background (or programming experience) is in Java or C, you can go with C#.
    If your background is with Visual Basic, you can go with VB.Net.

    In the .Net Framework you'll find the tools you need to communicate with your access database inside the System.Data.Oledb namespace.

    Hope it helps.
    LVL 3

    Accepted Solution

    Take a moment to weigh your options.  Access databases do not require that Access be installed on the workstations.  MS Access is a JET technology and can be connected to in Visual Studio using ADO or other technologies.  There are many things developed using JET.  That being said, typical JET databases, JET red anyways,  can be somewhat easily corruptible.  The alternative when using Visual Studio would be Microsoft SQL Server.  Microsoft has a free product  can SQL Express.  It has less limitations than MS Access and is just as easy to use in applications as Access.  

    From there, it is a personal choice.  Some people like VB.NET, others like C#, while others prefer Java.  All are object oriented and have their places.  VB.NET is used for quick application development.  It is a good language, but can be somewhat limited when compared to C#.  Java is also a good language.  I do not prefer Java due to the fact that is can be a challenge to keep up with the constantly updated releases.
    LVL 21

    Expert Comment

    I like the above answers but I would like to point out the Access run-time is fairly distributable.  You distribute it with your Access database and users can run it without installing the full-blown Access:
    LVL 39

    Expert Comment

    In addition to mastoo's comment: Access 2003 runtime could not be used if you have no Access 2003 Develpoer Extensions, but from Access 2007 it is free product. Most Access 2003 databases will work with Acces 2007 and 2010 runtime.
    If you have small databases, may be runtime will be enough. Try it.

    Author Closing Comment

    by:Ian Leason
    Sorry for delay in coming back to this question, I have been on holiday :)

    Thank you everyone for your help, the reason I chose this solution is it pointed out how easily corruptible Access databases can be. Thank you so much!!

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Threat Intelligence Starter Resources

    Integrating threat intelligence can be challenging, and not all companies are ready. These resources can help you build awareness and prepare for defense.

    The article will include the best Data Recovery Tools along with their Features, Capabilities, and their Download Links. Hope you’ll enjoy it and will choose the one as required by you.
    Skype is a P2P (Peer to Peer) instant messaging and VOIP (Voice over IP) service – as well as a whole lot more.
    The viewer will learn how to successfully download and install the SARDU utility on Windows 8, without downloading adware.
    Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…

    758 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    13 Experts available now in Live!

    Get 1:1 Help Now