Well, what I did was made a batch file that copied ALL the libraries to each
of the machines. I did it with a batch script in their startup so they
never knew. But, it was basically:
copy Z:\accessxp\libs\*.* %windir%
Contents of libs:
Volume in drive Z is NTShare
Volume Serial Number is 94CD-2C27
Directory of Z:\AccessXP\admin\libs
11/24/2004 04:48 PM <DIR> .
11/24/2004 04:48 PM <DIR> ..
01/25/2001 05:25 PM 570,128 dao350.dll
07/22/2002 03:05 PM 557,328 dao360.dll
03/07/2001 08:15 AM 435,616 MSACC.OLB
08/04/2004 12:56 AM 536,576 msado15.dll
08/03/2004 10:21 PM 61,440 msado20.tlb
08/03/2004 10:21 PM 61,440 msado21.tlb
08/03/2004 10:21 PM 81,920 msado25.tlb
08/03/2004 10:21 PM 81,920 msado26.tlb
08/03/2004 10:21 PM 81,920 msado27.tlb
08/04/2004 12:56 AM 180,224 msadomd.dll
08/04/2004 12:56 AM 57,344 msador15.dll
08/04/2004 12:56 AM 200,704 msadox.dll
05/08/2001 08:00 AM 1,503,504 msjet40.dll
12/07/1999 08:00 AM 74,000 msrclr40.dll
07/22/2002 03:05 PM 16,896 STDOLE2.TLB
02/16/2001 11:26 PM 483,328 UTILITY.MDA
01/22/2001 07:39 PM 2,498,560 VBE6.DLL
01/22/2001 07:39 PM 45,056 VBE6EXT.OLB
18 File(s) 7,527,904 bytes
2 Dir(s) 2,033,442,816 bytes free
That took care of it on all my OS's.. I have a mix of 98, 2000, and XP.
Isn't that special? I guess it's overkill to have multiple versions of
libraries, but it doesn't matter realty isn't an issue. The MDB just knows
which library it needs, and because it finds it in the sys path, then it's
happy with it's references. Missing references really tick me off in
particular because it's like "WHY DIDN'T THEY GET LOADED ON INSTALL?" Why
ask anything about Microsoft, or how, or why they do what they do. All I
know is I get to keep juggling to accomodate their changes - in everything.
-Brian
"Tim Marshall" <TI****@PurplePandaChasers.Moertherium> wrote in message
news:d3**********@coranto.ucs.mun.ca...
Ian Davies wrote:
Are these missing refs specific to the database or Access as a whole. Can
the missing refs be resolved from any Database or only from an mdb of the
one with the problem.
The reason I ask is that I only want the user to have the mde not the mdb
or
an I going to have to take a trip and visit the users pc?
I'm afraid it'd be a trip to each PC with an mdb copy and then create an
mde for that computer.
I'm not a 2002 user (I play with 97 and 2003) but it may be that the refs
in 2000 are different from 2002? If I'm wrong here, someone needs to club
me fast so I don't give Ian the wrong info.
If this is the case, what I would do is check the refs on a new mdb on one
of your 2000 machines and then change, if necessary, the refs on the 2002
machine before making it into an mde - that might do the trick.
--
Tim http://www.ucs.mun.ca/~tmarshal/
^o<
/#) "Burp-beep, burp-beep, burp-beep?" - Quaker Jake
/^^ "Whatcha doin?" - Ditto "TIM-MAY!!" - Me