compacting a repairing

P

Paul Reinholz

I have a database that has 2 tables. Both of these tables
contain an autonumber field which I would like to reset to
the value which is one higher than the highest value
currently in the table (records have been added and
deleted as test records). I have compacted it, which
worked before, but for some reason it doesn't seem to be
resetting the autonumber. Can anyone help me out with
this? Thanks!!
 
Top