Auto Number Field in MS Access

[SteFlitII]

Can I reset the value of an auto-number field in an MS Access Database through VB.
My problem is that I create new fields and also delete fields therefore the autonumber field is getting very large. Any help welcome

[Mark Sreeves]

YES!

I had a problem some time ago when the auto number kept resetting itself

Delete any unwanted data and compress the database this will re-set it!

------------------
Mark Sreeves
Analyst Programmer

Mark.Sreeves@Softlab.co.uk
A BMW Group Company