So I am trying to determine the main points for use of Macros and VBA. When I started using Access, I utilized Macros. It worked well for me since I had no real programming experience and Macro's appeared to be Newbie friendly. Now my database is starting to get slow. Someone (who, while smart, I would never believe over any of you) hinted to me that this could be due to the fact that I have many embedded Macro's running.
I know ideally I should be using VBA. From what I understand, it is a lot more flexible and allows for greater customization of automation tasks. I am just looking for input on what you think. I notice most people on here use VBA, but why?
And as a side question, does VBA actually load and run faster than a Macro?