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.