Rated
Read 37,359 times
Downloads
Related Categories
Access AutoNumber Reset
This is some sample code that shows how to programmatically reset all AutoNumber fields in an Access Database to a correct value (whether it be 0 or the max value + 1). In addition, it contains code for Compacting and Repairing an MS Access Database. This is perfect for people who are working with a complicated Access Database and have experienced AutoNumber bugs!
Current Occupation: consultant; Degrees: BS-Computer Science, BS-Mathematics, Japanese minor; Known Languages: VB, C++, SQL, PL/SQL, Java, PHP, ASP, Lisp
Comments
-
Posted by Roccoau on 23 Jun 2007
Hi only new to access so I am not sure I am doing the right thing.
When I run this I point it to my Database & run it. It goes through everything and completes successfully. But I canno... -
Posted by tunaroll on 01 Jun 2007
I agree with the others that the little autonum reset application is very nice however I've been banging my head over trying to use it with a db that has a username and password. It looks obviou... -
Posted by MrDeY on 02 Feb 2007
Thanks a lot!! This is a very useful application!! WELL DONE!
Dejan
-
Posted by dohertyo on 23 Sep 2005
I have been having the problem with autonumber reset for the past couple of months, and I am getting tired of having to delete the relationships, create a new table, copy the data etc... Can this rese...
Posted by Apoc on 10 Sep 2005
The code is part of a Visual Basic project (VB6). It uses an external ADO connection into Access in order to do the autonumber reset. You can do the same thing inside of access by adding a reference...
|