Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium


Best language to use for database program

Posted on 2012-09-18
Medium Priority
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 31

Expert Comment

ID: 38409912
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

ID: 38409958
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.

Accepted Solution

dave_tiller earned 1000 total points
ID: 38410023
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.
Efficient way to get backups off site to Azure

This user guide provides instructions on how to deploy and configure both a StoneFly Scale Out NAS Enterprise Cloud Drive virtual machine and Veeam Cloud Connect in the Microsoft Azure Cloud.

LVL 21

Expert Comment

ID: 38410041
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 40

Expert Comment

ID: 38410502
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
ID: 38462321
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!!

Featured Post

Upgrade your Question Security!

Your question, your audience. Choose who sees your identity—and your question—with question security.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Implementing simple internal controls in the Microsoft Access application.
A Case Study of using the Windows API to provide RS232 communications capability in Access without the use of Active-X controls.
Please read the paragraph below before following the instructions in the video — there are important caveats in the paragraph that I did not mention in the video. If your PaperPort 12 or PaperPort 14 is failing to start, or crashing, or hanging, …
In a question here at Experts Exchange (https://www.experts-exchange.com/questions/29062564/Adobe-acrobat-reader-DC.html), a member asked how to create a signature in Adobe Acrobat Reader DC (the free Reader product, not the paid, full Acrobat produ…

577 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