How to create a table programatically

[Zachary Turner]

I designed a database in access and I want to be able to generate this same
database programatically. The problem arises in writing the script to
generate this database. I'd think that access would be able to write a
script with sql commands that I could run and then generate this table, is
there a utility that can do this somewhere? It should of course, save all
the information into the script about primary keys, field properties, etc.

Thanks

 

[John Vinson]

I designed a database in access and I want to be able to generate this same
database programatically. The problem arises in writing the script to
generate this database. I'd think that access would be able to write a
script with sql commands that I could run and then generate this table, is
there a utility that can do this somewhere? It should of course, save all
the information into the script about primary keys, field properties, etc.

Thanks

Take a look at the TransferDatabase method in the VBA help.

Access is gradually and incompletely moving toward the SQL standard
whereby SQL DDE scripts can be used for defining and creating
tables... but IMO it's not really there yet. Certainly up through
Access2000 you must use either VBA code or the user interface to do
this.