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
Printable View
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
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
[email protected]
A BMW Group Company