Auto Number Turn Off

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..
 
D

Douglas J. Steele

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.
 

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


Top