Auto Number Turn Off

  • Thread starter Thread starter MyBad
  • Start date Start date
M

MyBad

I have a mdb database that I open with access.. I can edit everything but
the auto number part. I would like to be able to shut off that feature then
I think I will be able to edit the Numbers. Could someone tell me how to
shut off the auto numbering please? Then I need to able to resave it as a
mdb file. Thanks so much..
 
Why would you want to edit the autonumber values?

If you absolutely must, then you have to go into the table and change the
field type from Autonumber to Number (Long Integer). Be aware, though, that
once you do that, you'll no longer have an autonumber field in the table, so
you'll need to come up with some other way of providing a primary key.
 
Back
Top