We have software that uses Access as the data engine. The problem is that the table structures change with the new versions of the software. Is there a way to automate the changing of the tables and queries to match a "MASTER" copy or a table that defines all the fields and data types for the rest of the tables.
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Westi on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
verification of table structures
- Thread starter rfoote
- Start date
bin there
done that
mail me
email2jo@btinterenet.com & I will put it into A2k db and mail it back to you
if you want me to write the code to do a comparison and document the changes require and changes made you'll have to let me know.
I will make one provison that it isn't a runtime version.
regards
jo
- Thread starter
- #3
- Status
Similar threads
- Locked
- Question
- Locked
- Question
- Locked
- Question
- Locked
- Question