MS Access db (mdb): viewing table attributes

gau.tai at gmail.com gau.tai at gmail.com
Fri Mar 10 15:48:14 EST 2006


That would be fine for me to switch to mxodbc, I've used it before and
it worked fine.  But if I switch, do you know how I can get the column
names from the table?  Maybe I'm not being clear with my question here.
 I'm going to try again....

here's a table (it's in access):

=== tablename = mytable ===

id   |   user   |  pass   |   access privileges     <-- these are the
column names I want
================================
0        bob      12345     admin/full
1        sam     53432     power user
4        mike    43234     guest

I know how to connect to the database.
I know how to get the table names.
How can I get the names of the columns for each table??




More information about the Python-list mailing list