Hello all,
I am programming in Python to create an Access 2000 database. I am
creating a primary key column in my database, and want to set the
autoincrement property for this column. Here is what I have so far:
# create a table with the appropriate field names
table = win32com.client.Dispatch('ADOX.Table')
self.rs = win32com.client.Dispatch('ADODB.Recordset')
table.Name = "Cards"
#create the primary key column
table.Columns.Append('IDWAutoNumber', adInteger)
table.Keys.Append('Primary Key', adKeyPrimary, 'IDWAutoNumber')
I am stuck on the last step of how to get the IDWAutoNumber column to be an
autoincrement column. The only examples I could find are in VB, and I am
having trouble converting this to working Python code. Please help!
Thanks in advance,
Theresa
_______________________________________________
ActivePython mailing list
[EMAIL PROTECTED]
http://listserv.ActiveState.com/mailman/listinfo/activepython
