Using ADOX, Integer field set to Auto Increment

[JuggaloBrotha]

I'm using ADOX to create a database in memory, it's already setting up all the columns on it's own and i've got an ID field which is set as Primary Key already

the problem is that the ID field is a regular integer, I need it to be 'Auto Increment' but I dont know how

here's the list of all available datatypes for ADOX:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/ado270/htm/mdcstdatatypeenum.asp

any ideas?

 

[JohnH]

See if there is help in this MSDN article Use ADOX to Manipulate AutoNumber Fields

 

[JuggaloBrotha]

that very well may do the trick, i knew it had to be a property since the datattyp enumeration didnt allow the auto increment. thanx i'll give it a try tomarrow