MS Access verses Visual Basic

[Jon12345]

I am an experienced MS Access programmer. I use some vba with MS Access and I like it. However, I have always wondered what the Visual Basic development environment has to offer.

Are there any reasons why I should learn VB rather than just sticking with MS Access?

There seems to be so much moreinfo on VB on the internet than MS Access, so I am wondering why...

What am I missing out on?

Thanks,

Jon

[chrisjk]

Standalone exes is mainly the reason I switched
Also the fact you can protect your code (mde style - they didn't have mde's before I switched)
There are no nasty workarounds for knowledgable users (e.g Shift at startup)

Although I miss some things, like proper workable list/combo boxes.

[Hack]

Another hugh, cost saving for your customers reason, is that you can develop an app using Access with a VB front end, and your customers DO NOT have to have MS Access installed on their machines to use it!

Plus, VBA is a sub set of VB. You have extended programming functionality with VB.

[chrisjk]

Originally posted by Hack
Another hugh, cost saving for your customers reason, is that you can develop an app using Access with a VB front end, and your customers DO NOT have to have MS Access installed on their machines to use it!

Not entirely true, you can supply them with the runtime version of Access which can be installed simply with a setup app

[Hack]

Point taken chrisjk!