MS Access – Determining the Version of VB Used

ms accessvba

Which version of VB does MS Access use in the code editor? Is it VBA, VB.Net, other? I sometimes get confused when searching for help/solutions. For instance, in Access, you can't do:

Dim s as String = "hello"

But you can do:

Dim s
s = "hello"

Best Answer

All Microsoft Office applications use VBA. Excel, Access, Word, Outlook, and Powerpoint can be scripted using VBA. There are ways to extend this to shell scripting, ActiveX, etc and, by extension, a good number of other languages that those extensions can tap you into. I embed SQL into Excel VBA macros.

VB has a slightly different syntax and a different IDE.

Related Question