I was wondering if people would like to comment on how they like to deal with connection and recordset objects. Myself, I have recently been putting a public variable in a module that is the provider string and then utilizing that variable when opening my connection object. This works fine and keeps it in one place. Up until my most recent app I hve usually just put a Conenction object at the form level and had all recordsets in procedural code use this one object. Now I am building a new app I am toying with creating and destroying connection objects within my procedural code as I go. Can anyone comment on "best practice" (if there is one) for when and how often to create connections and recordsets?