Tejpal, A.D. - Autonumbers

Print Page | Close Window

Autonumbers_Reclaim.mdb

Printed From: Roger's Access Library
Category: Other Download Libraries
Forum Name: Tejpal, A.D.
Forum Description: A.D. Tejpal's Library
URL: www.rogersaccesslibrary.com/forum/forum_posts.asp?TID=139
Printed Date: 19 Apr 2024 at 2:01am
Software Version: Web Wiz Forums 12.03 - http://www.webwizforums.com

Topic: Autonumbers_Reclaim.mdb

Posted By: A.D. Tejpal
Subject: Autonumbers_Reclaim.mdb
Date 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: http://www.rogersaccesslibrary.com/forum/uploads/37/Autonumbers_Reclaim.zip - uploads/37/AutoNumbers_Reclaim.zip

-------------
--

Email: mailto:adtejpal@gmail.com - adtejpal@gmail.com