Err -2147221164 Class Not Registered using currentproject.connecti

P

Paul51

Hi,

I'm trying to use the Microsoft Access 2003 conversion database but keep
getting the error "Class Not Registered" when any line including a reference
to "currentproject.connection" is executed e.g.

set rPaths=New ADODB.Recordset
rPaths.Open "Select * from tblPathsToSearch", CurrentProject.Connection,
adOpenKeyset, adLockOptimistic

I have a reference set to Microsoft ActiveX Data Objects 2.7 Library and
have used regsvr32 to make sure that this is correctly registered.

Any suggestions/ideas gratefully received.
 
Top