Suddenly class is not registered?!??

[Malcy]

Hi
Really wierd and frustrating one. Have been using a database on an off-site laptop without any problems for 3 to 4 months. I updated some processes to ADO at the time and they have run perfectly.
Suddenly today I get a call to say an error message "Class not registered" appeared when running the system. The whole database then gets completely locked and you have to close things down using Task Manager.
Right enough it is on the form where I put the ADO and when I ran it on step through it fell over on the first bit of ADO
cnn = CurrentProject.Connection
I have checked the references and there are ticks alongside
Visual Basic for Applications
Microsoft Access 9.0 Object Library
OLE Automation
Microsoft ActiveXData Objects 2.5 Library

It is running on Access 2000 with Windows 98. I tried a detect and repair on Access just in case that fixed anything but to no avail.
Confess I am lost and I need to get the system up and running again by tomorrow morning.
Any suggestions would be greatly appreciated

 

[Malcy]

I have just run a copy of the database on my main PC (Access 2003 on Win XP Pro) and it runs exactly as expected.
Checked the references and it had
Visual Basic for Applications
Microsoft Access 11.0 Object Library
OLE Automation
Microsoft ActiveXData Objects 2.1 Library

I changed the ActiveXData Objects back to the 2.1 Library on the laptop and it still fails.

Do I have to uninstall the database, uninstall Office, re-install office and then re-install the database or is a simpler solution???
Thanks

 

[Malcy]

Another unsuccesful update on lack of progress!
I uninstalled Office 2000 then reinstalled it. Still same problem.
I tried removing the reference to Microsft ActiveXData objects, closing the module and then Access. Restarted Access. Compiled and it failed on the connection code so ticked the reference and compiled. It compiles 100% OK but still fell over when I tired to execute?
It runs perfectly on other PCs so feel it must be a Windows Registry problem but I don't know where even to begin!
Any help greatly appreciated
BEst wishes

Malcy