View Single Post
  #3  
Old November 24th, 2004, 12:01 AM
Glen Bodie
external usenet poster
 
Posts: n/a
Default

In the Table Design change the Autonum field to a Long Integer, make the
changes you want in the field values, change back to AutoNum.

"WWV" wrote:

I was worrking with a clients db and without going into details, they issued
2 new records in a table then I restored it. I need to put these records in
and generate 2 new records in a table with autonum field. There are 2 "open"
places for the records but I don't if it's possible to force add them and
PUT IN THE NUMBER I WANT? Can anyone tell me if this can be done?
ie. NUM existing 100 104 105 can I force 102 and 103?
THANKS
WWV