by J Burgess (2 Submissions)
Category: Databases/Data Access/DAO/ADO
Compatability: Visual Basic 5.0
Difficulty: Intermediate
Date Added: Wed 3rd February 2021
Rating: (3 Votes)
It dynamically writes the code needed to create a new tables/fields in an Access 97 database. You simply add the new fields and it writes the code. This is particularly useful if you have an existing application and wish to add new supporting tables when you release new versions of the software. Uses CreateTableDef and CreateField. This utility has saved me a ton of time.
Download Create new Table/Fields in Access with no code (11 KB)