Roger's Access Library Homepage
Forum Home Forum Home > Other Download Libraries > MS Access MVP Libraries > Tejpal, A.D.
  New Posts New Posts RSS Feed - Autonumbers_Reclaim.mdb
  FAQ FAQ  Forum Search   Events   Register Register  Login Login


Please consider donating $1 per sample downloaded, (find out why here)

Autonumbers_Reclaim.mdb

 Post Reply Post Reply
Author
Message
A.D. Tejpal View Drop Down
Microsoft MVP
Microsoft MVP


Joined: 30 Jun 2008
Status: Offline
Points: 192
Post Options Post Options   Thanks (0) Thanks(0)   Quote A.D. Tejpal Quote  Post ReplyReply Direct Link To This Post Topic: Autonumbers_Reclaim.mdb
    Posted: 10 Jul 2008 at 1:49am
This sample db demonstrates retrieval of missing autonumbers resulting from -
   (a) Aborting of newly entered record (which has already been made dirty).
   (b) Deletion of contiguous records towards the end (upto & including the last record).

The process is implemented in real time (at data entry stage itself) and is not
dependent upon Compact & repair action (in this context, compact & repair is found
to be effective only in versions up to Access 2K).

While reclaiming the autonumbers, data integrity rules do not get compromised.

Download Access XP & 2K: uploads/37/AutoNumbers_Reclaim.zip

--

Email: adtejpal@gmail.com
Back to Top
Sponsored Links


Back to Top
 Post Reply Post Reply
  Share Topic   

Forum Jump Forum Permissions View Drop Down

Forum Software by Web Wiz Forums® version 12.03
Copyright ©2001-2019 Web Wiz Ltd.