This problem sometimes occurs when the Data Access Object Library is not Registered Properly or its Reference is Broken.
I only know how to attempt this using Access 97 and 2000.
Do a search of your Hard Drive for:
Access 97 : DAO350.DLL
Access 2000 : DAO360.DLL
Take a note of the Path and Edit your Version below to the same(In Red).
Access 97 : Regsvr32 c:\Program Files\common files\microsoft shared\dao\DAO350.DLL
Access 2000 : Regsvr32 c:\Windows\system\DAO360.DLL
Don't worry if the Search throws up more than one File. Just choose the one that looks most like a System or Microsoft Path.
Next, Copy the above, (Your Version) selecting from the Beginning of Regsvr32 to the End of .DLL.
Click on the Start Button, Usually, Bottom - Right of the Screen. Select Run, Paste into the Open Text Box, Click on the Run Button. You'll either get a Successful or Failed Message. Try the Wizard again (Reboot First).
If this doesn't work there are a couple of other possible Remedies, but a lot more Complicated. Hopefully you won't need to, but I need to know your Access Version. Do you know what an Object Reference is and do you know what MDAC is.
Fingers Crossed
Bill
