Need To Go Back And Add An ID Column.

Yes I have a database loaded with information but no _ID column....

Adding the column is easy but how to assign each row incrementing values now - after the fact is my question...


I tried a :


Code:


"SELECT COLUMN " & _
"FROM " & _
"TABLE "



followed by:


Code:


While (NOT RS.EOF)
str_fixCol = "update TABLE " & _
"SET " & _
"CD_ID = " & CDID





but this times out at the server....
Any better ideas?

Measure twice cut once!!!
arggggg...