How Can I Insert a record between another rows?

[roshanak]

I have a table that it's PK Field Type is autonumber I want to enter a record between another records.so the other records after it should increase once.how can i do it with query?

[DiWa]

UPDATE table SET PK =PK+1 WHERE PK>=X INSERT INTO table(PK) VALUES(x) But your DB may not allow a direct access to the PK field, depending on the implementation. In that case, simply forget it. dirk