Autonumbers_Reclaim.mdb

Message Topic Search Topic Options Post Reply Create New Topic Printable Version Translate Topic

   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

Author	Message Topic Search Topic Options Post Reply Create New Topic Printable Version Translate Topic
A.D. Tejpal Members Profile Send Private Message Find Members Posts Add to Buddy List Microsoft MVP Joined: 30 Jun 2008 Status: Offline Points: 192	Post Options Post Reply Quote A.D. Tejpal Report Post Thanks(0) Quote Reply 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

Sponsored Links