Larry W Jordan Jr.
Derik Harris
Microsoft Corporation
Created: July 15, 1996
Revised: August 7, 1996
Larry W Jordan Jr. is a Senior Microsoft Access support engineer. His main focus is VBA, wizard and add-in development and Visual SourceSafe integration.
Derik Harris is a Senior Microsoft Access content engineer. His primary responsibility is writing, editing, and publishing Microsoft Access related material for the Microsoft Knowledge Base and the Microsoft Web site.
Click to open or copy the TBCCWIZ project files.
This wizard analyzes tables and indexes in a database, and then creates a VBA code module for re-creating your database as needed. A great tool for system administrators and database users who want to programmatically create new instances of a database.
This is a useful tool to use when you distribute applications that are split into a forms/code front-end and a data back-end scenario. Typically, you would ship both components, and when a new back-end database was required, you would copy from a disk or installation set and then start with the new database file. When you use code to create the database file, you can allow the user to create the database files when needed or control the process using permissions and the CurrentUser() object.
The Table Code Creation Wizard is a sophisticated tool that allows you to:
The resulting code, when run, will create the database structure from the code exactly as the original database was designed.
The Table Code Creation Wizard is designed to be used as an example of how to implement this functionality in a wizard and is not designed to be a solution for every design scenario.
The following features are not supported by the wizard: