My two cents...
your question is the classic consideration of the tradeoff between RAD
(rapid application development) tools and raw power. VB is so popular
because it is "easier" to whip up an application than C++. Especially
before .Net, C++ was considered to be faster and more powerful, and some
applications just demanded that.
In my opinion, designing a truly component-based (n-tiered, or whatever you
want to call it), object-oriented system in VB.Net is not something to be
taken lightly, even for someone with lots of VBA experience.
Bottom line is Access is great for very rapid development, and is quite
powerful within its contstraints, but VB, or any other .Net language for
that matter, is always going to give you more flexibility, power,
performance, etc. So, I guess the answer would depend on how fast do you
need to get something done, what is the expected future life and scaling
predictions, and what is the development skill available.
Perhaps this isn't anything you don't already know.
Daniel Billingsley, MCP
The Durcon Company
> Hello, I am a beginner in Visual basic. I am however, fairly competent in
> VBA within Access and Excel.
> At our company, we are determining whether to use VB.net or MS Access 2002
> as a front-end to SQL Server data. I am compiling a list of pros and
> Can some of you experts help me out with your comments? Thanks alot.