IDE reference confusion

[Alan Varga]

I am working with two databases in Access 2002 SP3, both databases are
in Access 2000 format; call them Time Tracking and Library. Library
has some standardized procedures I like to use in all production
databases, so I usually add Library as a reference.

I recently copied these two databases from my network folder to a co-
worker's network folder. My copy works fine, but hers lists Library
twice in the IDE Project Explorer window. If I rename Library in my
network folder, this solves the duplicate listing problem in her Time
Tracking, but none of the functionality is available, even though I
can view all of the VBA code.


If I use Tools/References in her Time Tracking, I see Library listed
once, unchecked, located in my folder, but everything works. If I
close her Time Tracking, rename Library in my folder and re-open her
Time Tracking, Library is not listed at all and functionality is
unavailable.


How can I get her Time Tracking to see her Library and forget my
Library? I can't "delete" a reference the same way I "add" a new one
(Tools/References/Add), and the References collection's FullPath
property shows her path for Library. I also can't unregister/re-
register the reference because it is not a DLL.

 

[Alan Varga]

I am working with two databases in Access 2002 SP3, both databases are
in Access 2000 format; call them Time Tracking and Library. Library
has some standardized procedures I like to use in all production
databases, so I usually add Library as a reference.

I recently copied these two databases from my network folder to a co-
worker's network folder. My copy works fine, but hers lists Library
twice in the IDE Project Explorer window. If I rename Library in my
network folder, this solves the duplicate listing problem in her Time
Tracking, but none of the functionality is available, even though I
can view all of the VBA code.

If I use Tools/References in her Time Tracking, I see Library listed
once, unchecked, located in my folder, but everything works. If I
close her Time Tracking, rename Library in my folder and re-open her
Time Tracking, Library is not listed at all and functionality is
unavailable.

How can I get her Time Tracking to see her Library and forget my
Library? I can't "delete" a reference the same way I "add" a new one
(Tools/References/Add), and the References collection's FullPath
property shows her path for Library. I also can't unregister/re-
register the reference because it is not a DLL.

The solution to replacing a reference is as follows:

1) go to the VBA IDE
2) click on an object from Time Tracking, NOT from Library
3) Library should now appear in the References list
4) uncheck the reference
5) save the IDE
6) exit both the IDE and Access
7) relaunch Access
8) return to the IDE
9) Library will not appear in the References list, good or missing
9) add the new location of Library as a NEW reference
10) save the IDE again

IT IS IMPORTANT TO DO THE TWO SAVES OR THE CHANGES WILL NOT STICK!!