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.