Update table in M.Access,code field,query

[Leite33]

Hi
I have made an application to connect Microsoft Access with Borland C to save some records!!!! My table in Microsoft Access has these fields:

code ->>>>>>>>>integer
Name ->>>>>>>>>>char
LastName ->>>>>>>>>>>>>char
Age ->>>>>>>>>>>>>>>>integer

Now i save the records correct to my table!!!!In code field count my records!!!
for examle: 1 Jim Dean 29
2 Leite Koontz 40
3 Melina Barker 20
4 Elina Smith 50

Now when i delete a record for example 3 row( Melina Barker) and save new record in code field will take number 5 but in table i have 4 records saved!!! How i can correct that????? With query??? But how??? Any code ideas????

[MrViggy]

Well, IIRC, typically the "code" column in a table functions like an ID, so it's always unique. Who is inserting the value for "code"?

Viggy