I need to change the properties of a field to be a primary auto number field. I know that we can't just change it so I am needing some code to copy the existing Contacts table structure. Change the ID field to Primary autonumber. Then we need to copy the contents of the original contacts table to the existing table, rename the old contacts to contactsOld and change the name of the temp table to contacts.
The reason for these gymnastics is that I am selling some software that will integrate with ShipRite and I need this to happen programitically so I don't have to physically go to each client to do the install.
I appreciate all the help.