By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
445,841 Members | 1,675 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 445,841 IT Pros & Developers. It's quick & easy.

VBA vs Visual Basic

P: n/a
Would it be better to use Visual Basic instead of VBA for Access
programming? Microsoft is giving VB (standard edition) away free
right now and I'm just wondering what the pros and cons are.

Nov 13 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
You can't "program Access" with VB... you can create VB applications that
access a Jet database (the default database installed and used by Access) or
VB applications that access a server database (for example, the desktop
version of Microsoft SQL Server -- MSDE -- that comes free with Access and
is an alternative to Jet).

But, if you are creating database applications to run under Windows, you'll
find that it is far and away easier and faster to do so in Access -- Access
is a database development product and an end-user interface to databases.

If you want to create web-based database applications, VB.NET (which would
certainly be what Microsoft is giving away, now, because the long since lost
interest in 'classic VB') would be a good bet.

Specific questions, with details, are the ones that get the best answers
here.

You don't "program Access databases in _either_ VBA or VB"... VBA is the
language that is built in to Access; VB and VB.NET are separate products.

Larry Linson
Microsoft Access MVP

"Bill" <wi***********@cox.net> wrote in message
news:a3********************************@4ax.com...
Would it be better to use Visual Basic instead of VBA for Access
programming? Microsoft is giving VB (standard edition) away free
right now and I'm just wondering what the pros and cons are.

Nov 13 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.