Automation type not supported

I am getting the error:
Automation type not supported in Visual Basic.

I never used to get the error but now that I have formatted my computer I am starting to get it in when referencing the Access 9 object:

Dim appAccess As Access.application

if I use :

Dim appAccess As Object

there is no problem...
why does this happen and how can I fix it?

Who is Participating?

Improve company productivity with a Business Account.Sign Up

kiprimshotConnect With a Mentor Commented:
You should try a total reinstall of Office 2000 to see if that solves the problem.
setfocusAuthor Commented:
That did it
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.