Autonumbers_Reclaim.mdb |
Post Reply |
Author | |
A.D. Tejpal
Microsoft MVP Joined: 30 Jun 2008 Status: Offline Points: 192 |
Post Options
Thanks(0)
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 |
|
Sponsored Links | Want a good read? Try The Summer of His Life (available on Amazon!) |
Post Reply | |
Tweet
|
Forum Jump | Forum Permissions You cannot post new topics in this forum You cannot reply to topics in this forum You cannot delete your posts in this forum You cannot edit your posts in this forum You cannot create polls in this forum You cannot vote in polls in this forum |