MISSING Microsoft ActiveX Data Objects 2.5 Library

[Bob McClellan]

Hello,
There is a user in a remote store using multiple .adps (2003) to access
databases residing in SQL2005.

His apps have been working fine for about a year. He now is having a
problem
with all his apps blowing up with MISSING Microsoft ActiveX Data Objects 2.5
Library.

He said that he has not installed any new software.

I logged into his machine and ran MDAC and then even uninstalled and
re-installed Access.

Problem still persists.
Many other users are using the same apps without a problem.

Any help this would be very much appreciated.
thanks in advance,
...bob

 

[Sylvain Lafontaine]

First, where does he see this error message? Is this in the References
window of the VBA IDE or somewhere else? If this reference is simply not
checked in the References window, did he try to simply add it (check it)
there?

Second, does he still have this problem if he creates a blank new ADP
project? If no then maybe a simple decompilation of all of his ADPs will do
the trick.

--
Sylvain Lafontaine, ing.
MVP - Windows Live Platform
Email: sylvain aei ca (fill the blanks, no spam please)
Independent consultant and remote programming for Access and SQL-Server
(French)

 

[Bob]

Thanks for the reply Sylvain.
He will be in the area on Tuesday and is bringing his laptop.
I will look at it then and try what you suggest.
what is the best way to decompile his apps?
...thanks in advance,
bob.

 

[Tom van Stiphout]

On Sat, 14 Feb 2009 20:24:05 -0500, "Bob"

There is only one way to decompile: the -decompile command line option
for msaccess.exe

-Tom.
Microsoft Access MVP

 

[Sylvain Lafontaine]

For the decompilation, you can use the /decompile switch of Access (along
with the options /compact and /repair); for example in the property of a
Windows shortcut (all of this on a single line):

"C:\Program Files\Microsoft Office\Office11\MSACCESS.EXE" "C:\MyADP.adp"
/decompile /compact /repair

I noticed that sometime, repeating this step twice in a row achieve a better
compaction ratio.

A second way is to change the References of the VBA: in the References
dialog window of the VBA environment, you add a dummy reference (anyone),
you cluse the dialog window (important!), you reopen it and you remove the
dummy reference that you have just added before. By changing the
references, you are forcing Access to recompile all modules when necessary.
You can also use the option "Recompile All" under the Debug menu (but only
after having made the previous change to the list of references).

Doing a Compact&Repair is not a bad idea after that.

--
Sylvain Lafontaine, ing.
MVP - Windows Live Platform
Email: sylvain aei ca (fill the blanks, no spam please)
Independent consultant and remote programming for Access and SQL-Server
(French)

 

[Bob McClellan]

Thanks Tom and Slyvain!
I will work through this tomorrow when the laptop gets here.
thanks again for the help.
...bob.

 

[Onur KOÇ]

Hello,
There is a user in a remote store using multiple .adps (2003) to access
databases residing in SQL2005.

His apps have been working fine for about a year. He now is having a
problem
with all his apps blowing up with MISSING Microsoft ActiveX Data Objects
2.5 Library.

He said that he has not installed any new software.

I logged into his machine and ran MDAC and then even uninstalled and
re-installed Access.

Problem still persists.
Many other users are using the same apps without a problem.

Any help this would be very much appreciated.
thanks in advance,
..bob