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!!
 

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