def __init__(self, data_source, user, pwd="''", mdw="''"):
        """Returns a connection to the jet database
        NB use .Close() to close (NB title case unlike closing a file)"""
        self.connAccess = win32com.client.Dispatch(r'ADODB.Connection')
        """DSN syntax - http://support.microsoft.com/kb/193332 and 
        http://www.codeproject.com/database/connectionstrings.asp?
        df=100&forumid=3917&exp=0&select=1598401"""
        DSN = """PROVIDER=Microsoft.Jet.OLEDB.4.0;DATA SOURCE=%s;
            USER ID=%s;PASSWORD=%s;Jet OLEDB:System Database=%s;""" % \
            (data_source, user, pwd, mdw)
        #print DSN
        try:
            self.connAccess.Open(DSN)
        except Exception:
            raise Exception, "Unable to open MS Access database " + \
                "using DSN: %s" % DSN
Returns a connection to the jet database
        NB use .Close() to close (NB title case unlike closing a file)
recipes/Python/528868_Extractimanipulaticlass_Microsoft/recipe-528868.py