Access VS MS.Net

Posted on 2007-08-09
Last Modified: 2013-11-26
Hi evereyone.
I am looking at what Access has to offer in terms of VBA functionality compared with Microsoft.NET backend.  Any Ideas on the way forward here because up to now I have been very comfortable with MS Access but with the advent of 2007 there are quite a few changes that I have to make to a lot of the databases that we have already written.  I am seriouly thinking of going the route but the question then is what Front End.  Your thoughts will be appreciated
Question by:caandal
    LVL 77

    Assisted Solution

    Most developers would regard the tables as the Backend.  Access UI is the front-end.

    In the ms world the common alternative would be .net and SQL Server, but don't expect it to be as easy as Access.

    LVL 84
    As pete said, the learning curve for these languages can be steep, especially if you're a "drag and drop" Access programmer, or someone who doesn't have a lot of OO experience.

    I've had little trouble with Access in fairly large multi-user environments, but then I'm running my apps in full unbound mode so I avoid most of the performance troubles so often seen. If you have a wide user-base - especially if those users may or may not have Access 2007 installed - then the answer would be (to me, at least) to move to the .NET platform ... if this is a small workgroup on the same LAN, then Access will handle it easily.

    Author Comment

    Thanks guys for the comments.  I regard  Access as the front-end - VBA sitting behind Access to all the nice things and then the Tables as the back end Currently depending on the application I stay with Access as the data holder in a small environment or use SQL as the back end in larger environments or with lots of data.  I am very comfortable using VBA and must say that I don't use drag and drop or the wizards in Access very often.
    LVL 84

    Accepted Solution

    Most devs find the jump from Access to the .NET languages (like VB.NET) to be something of a challenge, especially those who have little Object experience (the .NET languages are extremely OO intensive), or those who use bound forms almost exclusively. That said, migrating to one of the .NET languages is good experience, and is sure to shore up your resume!

    Your question, however, doesn't make sense is some ways ... "VBA functionality" and "backend" have no real bearing on each other. Taken separately, .NET is much more feature-rich than VBA (at least in my opinion), but - again - will require you to learn a new language. As to backends - as discussed before, use the tool that fits the job, as you've done in the past. In general, referring to ".NET" would indicate one of the "frontend" languages, but you appear to be talking about backend systems ... perhaps that's why our answers may seem a bit confusing.

    If I understand you correctly - you're currently using Access 2003 or earlier and are looking at moving to one of the .NET languages for a frontend, and SQL Server, MySQL etc for a backend - then, again, use the tool that fits the job. If you're building something for a small workgroup, then Access (2003 or 2007) would be a fine choice. If it's something to be deployed beyond your small workgroup, then it may be time to consider .NET with a more robust backend.

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    IT, Stop Being Called Into Every Meeting

    Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

    The first two articles in this short series — Using a Criteria Form to Filter Records ( and Building a Custom Filter ( — discuss in some detail how a form can be…
    QuickBooks® has a great invoice interface that we were happy with for a while but that changed in 2001 through no fault of Intuit®. Our industry's unit names are dictated by RUS: the Rural Utilities Services division of USDA. Contracts contain un…
    In Microsoft Access, learn different ways of passing a string value within a string argument. Also learn what a “Type Mis-match” error is about.
    The viewer will learn how to use and create keystrokes in Netbeans IDE 8.0 for Windows.

    737 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

    22 Experts available now in Live!

    Get 1:1 Help Now