insert missing numbers in an autonumber field

[Guest]

i accidentally erased some sequential numbers in an autonumber field on a
table, can anyone lease tell me how to re-insert the missing numbers back
into the autonumber field T H A N K S

 

[Douglas J. Steele]

Already answered in another newsgroup to which you posted the same question.

If you feel you need to post to more than one group (HINT: it's seldom
necessary), please have the courtesy to cross-post (send the one message to
all groups at once), rather than multi-post (send individual messages to
each group). In this way, all responses to your post will be available
together, regardless of what group the responder was in, and the rest of us
won't have to read your post multiple times. (It also uses fewer server
resources)

If you're using Microsoft's web interface to post, I believe that you can
type the names of the various groups into the Newsgroup box. Separate each
newsgroup name with a semicolon.

Note that it's generally consider to be A Bad Thing to cross-post to more
than about 2 or 3 newsgroups. (In fact, at
http://www.microsoft.com/presspass/features/2001/Mar01/Mar27pmvp.asp
Microsoft suggests that "One group will suffice")

 

[Robin Chapple]

Doug,

Whilst I agree with your comments, I am interested in the response. I
only subscribe to this Access newsgroup. Which other newsgroup was
involved please?

Yes a blast from the past. <G>

Robin Chapple

 

[Douglas J. Steele]

Sorry, I answer too many questions to keep track of what group it was in.

You can try doing a search at http://www.google.com/advanced_group_search to
find it. You know the name of the original poster, you know the subject of
the original post, you know the date of the original post, and you can
assume that the newsgroup is microsoft.public.access.* (make sure you
remember the asterisk) That should return a limited list that you can then
check for the answer.

 

[Randy Harris]

Doug,

Whilst I agree with your comments, I am interested in the response. I
only subscribe to this Access newsgroup. Which other newsgroup was
involved please?

Yes a blast from the past. <G>

Indeed! At least two others, besides Doug, replied to the message in that
group.