Mark L. Breen
subs at solution-providers.ie
Wed Mar 12 03:17:00 CST 2003
Hello Susan, Would the explanation be that in your sample code With cmd .ActiveConnection = strConn It appears that the connection is being initialised here. Perhaps in the other example, it reads clearer when you are passing in a live cnn connection rather than strCnn. Having said that, you could use cnn in both scenario's. I do think ( as I think you do ), that your way is neater. For a further question on this, see my new thread 'Using Global Connctions' Best Regards Mark L. Breen Solution Providers Ltd Ireland ----- Original Message ----- From: "Susan Harkins" <harkins at iglou.com> To: <accessd at databaseadvisors.com> Sent: Tuesday, March 11, 2003 10:01 PM Subject: Re: [AccessD] ADO Command object -- I still don't see the advantage of using the Connection object instead of a connection string. I'm not arguing -- I just don't understand. The light's not going on. :) Susan H.