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.
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.'
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.