I have an Access 2003 database, protected by a workgroup, that I am trying to view through python. Currently, I'm attempting dao with the win32 package, and I'm able to view all of the table names, but I don't know how to view the attributes of the tables.
My code: import win32com.client from pprint import pprint #sample code to list all tables in the selected database daoEngine = win32com.client.Dispatch('DAO.DBEngine.36') dtbs = daoEngine.OpenDatabase('database_file.mdb') for table in dtbs.TableDefs: if table.Name[:4] <> "MSys" and table.Name[:4] <> "~TMP": pprint(table.Name.encode('utf-8')) #the above works, but below does not: for col in table.Fields: pprint(col.Name, Col.Type, Col.Size) I am getting that len(Fields) = 0, and I know the database tables are all full of columns (and data). Is there also some resource that defines all the properties of TableDefs? I wasn't able to find a python reference for this. Thank You, Gau -- http://mail.python.org/mailman/listinfo/python-list