Can I use an existing table in Access to create code to build an identical table
Posted on 2012-03-09
I have an application that uses an access database with several large tables. I want to write a program that will dynamically build the database for new users instead of having to provide them with a copy of a blank database.
I prefer not to have to manually type up the code to create each of the tables with the correct field names, type, and sizes. I figure that I could load the table and go through the fields collection and append each field to a build a create table command.
But is there an automated way that would do this for me from an existing table structure.