how do i add an auto number coloumn within a current database.?

[Sum1t.V.]

hiya, to all u'm persons out there online with ur expert knowledge in ms
access i have a problem in my database that i created.

i did not insert a column with auto number.

i have no problems placing a column within the db. But access does not
allow me to "call" the column "auto-number"?

r ther any sgguestations? that i can apply?

i'b be most gratefull for any ideas and replys.

yours truely,

Sum1t.V.

 

[Jeff Boyce]

Is there a chance the table already has an Autonumber column? What error
message does Access give you when you try?

 

[toga371phy]

1) Copy your existing table, then select paste.
2) Give it a different name and select Struture Only.
3) Edit the new table (design mode) and add the autonumber field that you
want.
4) Close the table and then go to Query's.
5) You want to create a new query loading your original table into the
design window.
6) Bring all of the fields down and select the Append query type. It will
ask you which table you want to append to. Select the new table you created.
7) Simply run the query and the autonumber field you created will be
automatically populated as the data is appended.
8) Close out of the query (No need to save) and open the new table you
created to verify all is OK....which it should be.
9) Assuming it is, delete the original table (Or rename is sonmething else
if you want to hang on to it for a bit) and then rename the new table with
the original table's name.
10) Your done!