Help with editing client number field

[Jessica]

I accidentally deleted an important client record from the database. I have
re-entered all of the data, and want to change the Client # back to what it
orignally was. However, I had to create a new record and a new client number
was automatically assigned. I have tried to change the number back to the
old one but I cannot edit the field. Is there any way to restore the old
client number? Thanks!

 

[Allen Browne]

Use an Append query to add the clikent, instead of typing it in.

You can assign the number you want to the AutoNumber field if you use an
append query.

 

[KARL DEWEY]

I assume that the Client # is an autonumber field.
Backup your database.
Create a temp table with just the one record and have the field number -
long integer.
Edit the number to what it should be.
Delete the record in your main table.
Compact and repair. Close Access. Open Access.
Create an append query from the temp table to your main table and include
the field for Client #.
Check the record in the main table to see if it has the correct Client #.
Delete the temp table.
Compact and repair.
Done.

 

[fredg]

I accidentally deleted an important client record from the database. I have
re-entered all of the data, and want to change the Client # back to what it
orignally was. However, I had to create a new record and a new client number
was automatically assigned. I have tried to change the number back to the
old one but I cannot edit the field. Is there any way to restore the old
client number? Thanks!

No... there is no way to restore the old client number... nor should
there be.
If it's simply a matter of no longer having consecutive client
numbers, that shouldn't matter. The AutoNumber need only be unique.
It's not necessary to be consecutive.

Perhaps though, depending upon your database set-up, you could replace
the entire table with a back-up table, (you have been backing up your
data, haven't you?) then add what ever additional records entered
since the back-up was saved.