When using Access VBA Programming, there is no executable created outside of the Access application correct?
In other words, there is no stand alone program created by using Microsoft Access with VBA programming.
All of the execution is done within Microsoft Access application using the objects like forms and reports that associate with VBA.
So all users must have the Microsoft Access application which has access to an access database with these components like Reports or Forms. Thus the users are sharing an access database.