Class not registered error on CurrentProject.Connection

[Scott]

I have a database that was on my old PC running Win
2000. I recently moved it to my new PC running Win XP.
When I try to execute the modules in the database, I
receive a "Class not registered" error on this step:

rs.Open "[Table_Agent]", CurrentProject.Connection,
adOpenKeyset, adLockOptimistic

I checked and I have MDAC 2.5 on both. Tried downloading
MDAC 2.8 but didn't fix the problem. References are the
same on both the old and new.

Any suggestions would be greatly appreciated.

Thanks

 

[Dev Ashish]

I checked and I have MDAC 2.5 on both. Tried downloading
MDAC 2.8 but didn't fix the problem. References are the
same on both the old and new.

Try downloading the latest Jet service pack.

[ http://www.microsoft.com/downloads/details.aspx?FamilyID=2deddec4-350e-
4cd0-a12a-d7f70a153156&DisplayLang=en ]

-- Dev

 

[Dev Ashish]

I downloaded the latest Jet files and didn't fix the
problem either. Thanks.

See if Component Checker tool reports any problems.

[ http://www.microsoft.com/downloads/details.aspx?FamilyId=8F0A8DF6-4A21-
4B43-BF53-14332EF092C9&displaylang=en ]

-- Dev