I am using Access 2003 with some VBA code. The VBA code accesses the data from an ADODB.Connection call. To enable this in my testing environment I need to go to Tools -> References and select one of the MS ADO references to get that line of code to work.
Does doing this affect only that one Form object or does the reference become active for the entire database.
Really my concern is this. The database is heavily used in a Classic ASP/IIS environment. I do not want this reference to override what the ASP processor is using to process the SQL code. Also, I don't want to open up some sort of additional vulnerability.
I'm a newbie to VBA and am unclear of the ramifications of adding the reference are.