Changing Field properties with ADO

[venom3249]

How do I change the field properties of an access database using ADO. I've got a procedure that creates the table and and all the fields but I want one of the fields to autoincrement. How would I go about setting that? Thanks.

 

[lovell811]

this should at least give you an idea this is to create a field:

table.Fields.Append table.CreateField("fieldname", dbInteger) ----------------
Joe

 

[venom3249]

Thanks for the reply Joe but I got the fields created already. I'm looking for a way to change the field's property.

 

[johnwm]

In Access you can't change a field to Autonumber after the field has been created. The nearest that you will get is to add anew field and set its Datatype to Autoincrement Let me know if this helps
________________________________________________________________
If you are worried about how to post, please check out FAQ222-2244 first

'There are 10 kinds of people in the world: those who understand binary, and those who don't.'