Re-auto number

C

CarrieStory

I imported record numbers into an auto number field. Now every time I view
that field (always!) I get an error message telling me that the data is
incorrect.

Can I re-number the records?

THANKS!
 
L

LDSFARM

You could try copying the record numbers to another "new" field and then
removing the auto number field.
 
L

Larry Daugherty

Don't start a post with "Re" That's reserved for Replies.

You'd be better off to delete the records at fault and then re-import
without the record number field.

I guess my education/experience is lacking. I thought that Access
would refuse to import records with non-null data in the Autonumber
field.

HTH
 

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

Top