Thank you everyone for your posts. Listed below is the correct code, solution reached. And to include the username and password you can simply inter it behind Persist Security devieded off with semicolons.
con = win32com.client.Dispatch(r'ADODB.Connection') DSN = r'Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\test.mdb;Mode=ReadWrite;Persist Security Info=False' con.Open(DSN) -- http://mail.python.org/mailman/listinfo/python-list
