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.
 
I think I did that AutoNumber and I culdnt erase and I brake the Cd of Mic
Office
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

sorting with auto numbering 3
Auto numbering 1
The next Grand Theft Auto title has been officially announced 0
Auto Numbers 3
Auto Number ID Field 4
auto copy 5
Auto number 3
auto number in query 1

Back
Top