Creating Access DB using script

[karlomutschler]

Hi all,
how do I create a db, tables and fields using a script ?

Is it possible to view the code for a db with tables and fields created by using the db-assistant ?

Thanks and kind regards
Karlo meistertools@gmx.net

 

[randysmid]

Hi,
Here is a link to the MSDN page that shows how to accomplish this task within VBA code. It uses the "CreateDatabase" method.

http://msdn.microsoft.com/library/d...y/en-us/off2000/html/acmthCreateDatabaseX.asp

The sample also shows how to create a new table with two fields.

Good luck !!!! If this tip has been helpful, be sure to click on the "Mark this post as a helpful/expert post!".

Randy Smith
California Teachers Association