cashhaa.blogg.se

If you don't explicitly declare the library, Visual Basic will assign a library and you might not get the one you intended. First, referencing the library is self-documenting. However, if there's even a remote chance that you or someone else might reference the Data Access Objects (DAO) library, you should explicitly declare the ADO library. As long as you've referenced the library, the object will be available using the following syntax: Dim cn As Connection Technically, it isn't necessary to explicitly declare the library. When declaring an ADO object, it's best to include the ADODB library qualifier as follows: Dim cn As ADODB.Connection Admittedly, with today's powerful systems, it hardly seems necessary, but it's still considered the right way. Every reference to the new but undefined object forces Visual Basic to check the object.ĭon't use the New keyword until you're ready to reference the new object in code. When you include New in the declaration (Dim) statement, Visual Basic works harder. Granted, two statements where one will do, seems inefficient. But that shortcut won't perform as well as the following: Dim cn As ADODB.Connection