I have a database in Access and in its tables the primary key is auto complete. But the problem is that when I delete one feild say its id is 2 then when add new record it generate 3 for its id feild. I want this that when a record is deleted it Id will assign to very next record which will be inserted after the deletion
Please tel me how can I do this ?
 Thanks in advance.


(*_*)

Numan
--------------------------------------------------
It is not important what you get But important is how you got it

__________________
(*_*)

Numan
--------------------------------------------------
It is not important what you get But important is  how you got it

Be very careful using the method you mention and what you are trying to accomplish. In a multi-user environment as you can have two users getting the same number. If your application is multi-user then you need to create a separate table to store
the current maximum number. If the auto number is just serving as counter, reseed it.


Jaime E. Maccou
Applications Analyst
mailto:[email protected]

"Our lives begin to end the day we become silent about things that matter."

- Dr. Martin Luther King, Jr.

"The mind does not take its complexion from the skin..."

- Frederick Douglass

There is always a way to do it better . . . find it!" Thomas A. Edison