Decision Between MS Access 2010 or VB.net

Question

Well I am stuck with a question. That should I start using VB.net as a new application development kit instead of MS Access. I mean, I am an Expert in Access and I have to learn VB.net. I can do this as well but obviously I need a strong reason to switch. Some of my clients asked me to develop Application in VB.net.

I need a suggestion that which one is better for database with SQL Server 2008? and I would really grateful if you give me a reason for why I select you opinion....

---

Regards, Wasif Shahid ACCEDER software

Answer 1

All other things being equal, you will enjoy working with VB.net because you will replace the VBA "IDE" and work with a professional tool: Visual Studio. Don't look back!

---

peter n roth - http://PNR1.com, Maybe some useful stuff

Answer 2

vb.net is a language within the .net framework, and can be used for windows forms, asp.net apps, and several other kinds of applications. If your clients are asking for vb.net apps, vs access apps, the most direct comparison would be windows forms. You'd have to ask them why they want vb.net over access. There are good reasons to choose windows forms over access, and the other way around too.

Data binding is much simpler in Access, and the excellent job the Access team did with that in the 90s is why Access is so great for many tasks. It's a lot more work doing the same thing in windows forms. Try some experiments, you'll see for yourself. On the other hand windows forms ultimately has more depth than Access.

Both Access and windows forms are not getting any substantial developer attention from Microsoft. You might consider looking at lightswitch. In some cases it is a good solution.