<div>
<div class="content wysiwyg-content">
I am getting the error:<br />
Automation type not supported in Visual Basic.<br />
<br />
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:<br />
<br />
Dim appAccess As Access.application<br />
<br />
if I use :<br />
<br />
Dim appAccess As Object<br />
<br />
there is no problem... <br />
why does this happen and how can I fix it?<br />
<br />
<br />

</div>
</div>


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?




Automation type not supported

Visual Basic is Microsoft’s event-driven programming language and integrated development environment (IDE) for its Component Object Model (COM) programming model. It is relatively easy to learn and use because of its graphical development features and BASIC heritage. It has been replaced with VB.NET, and is very similar to VBA (Visual Basic for Applications), the programming language for the Microsoft Office product line.