Hi Gurus,

In a mdb, there is a table with auto-incrementing field. During my tests and trials, recs were added, deleted etc, and this field value is now some 300+.
I want to deploy the DB into client's machine, and i have made a "distribution DB" with no records, just the bare table structure. I want to reset this auto incr field also to zero, so that when he adds recs it starts with 1.
How do i do it?

VB 5.0, DAO 3.5, Access DB.

As an aside, how do people distribute databases?
DO their setup programs create DB on the run? or copy a no-record sample DB like i am trying? What is the best method?

RK