Primary Key!

[Ielamrani]

How can I add a primary key (number)to an existing empty field?

This is the table I have:

Id Name Title

John Director
Paul Analyst
Puala Programmer

I would like to add in the ID field 1 to John, 2 to Paul and 3 to Puala ect..

Thanks in advance

 

[PHV]

DoCmd.RunSQL "ALTER TABLE myTable DROP COLUMN Id"
DoCmd.RunSQL "ALTER TABLE myTable ADD COLUMN Id COUNTER(1,1) CONSTRAINT PrimaryKey PRIMARY KEY"

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[Ielamrani]

As usual you're amazing. Thanks a ton.
Ismail