I have an access 97 table that has an AutoNumber field that I need my program to change from an Incremental AutoNumber field to a Random AutoNumber Field.

I must not loose the existing data in the field, and would like to do this using ADOX.

Is it possible? If so how?

MS Access will let me convert the field manualy through the table design so it looks like it should be achievable.

Any help greatfully received.