AutoNumber question

[Thedon123]

I have a primary key that is already autonumbered in an existing database.

I need to remove the autonumber so i can change the primary key to a text field. hoew would i remove this autonumber.

 

[79ssecca]

Create make table query that includes all columns except the autonumber column.

ssecca

 

[Rich]

Do you have Child records as well?

 

[Thedon123]

yes i have child records also.

 

[Thedon123]

sorry ssecca i do not understand your answer. do you want me to create another query but without the autonumber then use this qury instead of the table with the autonumber in the relationships.

 

[79ssecca]

My understanding is you want to permenently remove the autonumber column for a table. If this is so, you can crete a "Make Table Query" that includes all the current columns except the autonumbered column. Running that query will copy the curent table to a new table without the autonumber field. then rename the new table to the old name create your new index your all set.

Now if there are related tables that use the exsiting autonumber as a reference this still is not a real problem. use a cstr() function on the autonumber field when making the make table query and then later on reconvert it back to a number so that you can maintain your links off of those numbers.


Good Luck
ssecca

 

[Thedon123]

i have decided to give in to the idea of removing the autonumbere. thanks for all your advice it is really appreciated.