[AccessD] Resequence All Autonum Fields - a tentative approach

Bill Benson bensonforums at gmail.com
Thu Jan 1 16:14:01 CST 2015


I have updated the solution. I still consider it a work in progress and I
will still report under this thread any progress. If not interested, just
ignore, I realize that Jim and Charlotte's negation of the idea may well be
representative of the entire community, but if I have code I know to be
defective, I want to provide fixes as I see them required. So forgive me
for beating a dead horse.

https://drive.google.com/file/d/0B-Klb4AlrC9JaExTV1p3d2JBSXc/view?usp=sharing


The new revision adds a column to the temp table for every required field
which was not accounted for by virtue of relationships to other tables.
There is a function to convert DAO to DDL field types as well - I may or
may not have made valid guesses.

I think there is still one more step which I shall have to investigate
sooner or later, and that is, any fields in the primary table which are
RELATED to other fields in the database but which are NOT of type Long. The
current and former "release" of this solution are modeled after my own
databases in which I do not relate fields which are not type Long and/or
autonumbers. So if you are playing with this, watch out for that.


More information about the AccessD mailing list