<div>
I am not sure. &nbsp;I am trying to work on this program on my laptop and my pc. &nbsp;Now I did check and the pc has a newer version of the DLL and it works just fine. &nbsp;
</div>


I am not sure.  I am trying to work on this program on my laptop and my pc.  Now I did check and the pc has a newer version of the DLL and it works just fine.  

<div>
okay, what I have done was to copy the newer version of the dll from my pc to my laptop. &nbsp;Now the dll works just fine. &nbsp;When I run the program I get this error:<br />
<br />
Run-time error '429':<br />
<br />
ActiveX component can't create object<br />
<br />
it is this line of code that causes the problem:<br />
<br />
If Cnn.State = adStateOpen Then Cnn.Close<br />
<br />
any ideas?
</div>


okay, what I have done was to copy the newer version of the dll from my pc to my laptop.  Now the dll works just fine.  When I run the program I get this error:

Run-time error '429':

ActiveX component can't create object

it is this line of code that causes the problem:

If Cnn.State = adStateOpen Then Cnn.Close

any ideas?

<div>
You cannot just copy the DLL. You have to install MDAC. You can get it from <a href="http://msdn.microsoft.com/data/downloads/updates/default.aspx#MDACDownloads" rel="ugc">http://msdn.microsoft.com/data/downloads/updates/default.aspx#MDACDownloads</a>
</div>


You cannot just copy the DLL. You have to install MDAC. You can get it from http://msdn.microsoft.com/data/downloads/updates/default.aspx#MDACDownloads [http://msdn.microsoft.com/data/downloads/updates/default.aspx#MDACDownloads]

<div>
<div class="content wysiwyg-content">
I am working on a program that connects to a database. &nbsp;I have the following statement:<br />
<br />
If Cnn.State = adStateOpen Then Cnn.Close<br />
<br />
But when I run the program I get an error (adStateOpen can't find project or library), am I missing a Reference and if so how do I add the reference. &nbsp;The reason I ask is that when I go to Project -&gt; References it says MISSING: Microsoft ActiveX Data Objects 2.7 Library. &nbsp;Now I have followed the path that it gave for the correct DLL and it is there. &nbsp;Can someone please help.
</div>
</div>


I am working on a program that connects to a database.  I have the following statement:

If Cnn.State = adStateOpen Then Cnn.Close

But when I run the program I get an error (adStateOpen can't find project or library), am I missing a Reference and if so how do I add the reference.  The reason I ask is that when I go to Project -> References it says MISSING: Microsoft ActiveX Data Objects 2.7 Library.  Now I have followed the path that it gave for the correct DLL and it is there.  Can someone please help.

Missing Reference in VB 6.0

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.