Acces Dim Statment (Global VS Standard Dim)

[airon]

I have created a reporting DB. The DB generates reports via MS VBA code. there are several modules that are involved in running this DB. I Currently have one Module that holds all Global Declarations for common used variables in all modules.
Question?
Is diming Global Statemts memory intensive?
If I trying to conserve memory used by this reporting DB. Would I be beter off to dim each variable as specific as possible. By specific I mean putting dim statements in each module.