The specified module could not be found

[Bubu]

When I astart the Access 2000 application, I recives the error message
"The specified module could not be found". If I click the debug button
the VBA code points to

rst.Open strSQL CurrentProject.Connection, adOpenForwardOnly,
adLockReadOnly

In reference I select "Microsoft AvtiveX DataObject 2.1 Library".

Can any one please help.

 

[Alex Dybenko]

So, you have to stop your code, go to menu tools-references and add a
reference to ADO 2.1 or any higher
if you dont have it there - you can install one from:
http://msdn.microsoft.com/data/Default.aspx

 

[Bubu]

I did that also. I tried adding ADO 2.1, 2.5, 2.6 and 2.7, but still
same error.
Previously the application was working fine. But from last one or two
weeks it is throwing this error.

 

[Alex Dybenko]

Hi,
Make a stop at this line:

rst.Open strSQL CurrentProject.Connection, adOpenForwardOnly, adLockReadOnly

then open debug window and type
?CurrentProject.Connection
if this one produce error - then try to use
CurrentProject.ActiveConnection instead

i rememeber i had something similar long ago in Access 2000

 

[Douglas J Steele]

Is that a cut-and-paste of the actual code? You're missing a comma between
strSQL and CurrentProject.Connection

 

[Bubu]

It is not a cut and paste. The comma is there in the actual code.