Quote Originally Posted by Simon Lloyd
Ken your title is well deserved - clear - concise explanations and responses!
LOL! Well thanks.

Quote Originally Posted by Simon Lloyd
one question i missed out (sorry!) as we are networked (in excess of 800 machines) naturally none of us have administrator rights, therefore if a machine does not have ActiveX (as sometimes when using the web you are asked to allow ActiveX) and we are trying to use that to manipulate the db will we recieve an error or would the code just hang?
Good question. I don't believe that there should be an issue here, as I've never been presented with an ActiveX prompt when doing this. The only way to know for sure, though, is to test it out.

Quote Originally Posted by Simon Lloyd
i had the urge to write an If statement to try to capture this but on viewing the code in the class module it looks like it would be the ADODB Connection that would have to be handled if this was the case, i wasn't sure of the language around that is it vb, vba, sql..etc.
Well, if there was an issue, it would be around the ADODB connection yes. Don't overthink the languages in use here, though.

SQL is a very small portion of what we're doing. It's simply the query to extract data from the database. A one liner that is sent to the database via the ADO connection.

The ADO is just a class that can be leveraged by VB, VBA or other languages. While it makes use of arguments that need to be provided correctly, it's not really a languae per se.

As for the VB vs VBA, the two intermix. VBA is an application specific flavour of VB. When we're programming, we constantly intermix VB and VBA. If you look up items in the help files, you'll see some marked "Visual Basic".