Ken your title is well deserved - clear - concise explanations and responses! 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?, also if ActiveX is installed on the machine but is set to "ask to allow ActiveX" would we have similar problems? 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.

There are only 2 other VBA'ers here that i know of and i hate to admit it but i (up until now) felt that i was the more experienced of us!

Regards,
Simon