A
Alan Varga
I am working with two databases in Access 2002 SP3, both 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 Time Tracking and Library 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 only 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.
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 Time Tracking and Library 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 only 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.