How to generate CREATE TABLE statements for tables

		Wrox Programmer Forums > Microsoft Office > Access and Access VBA > Access VBA
How to generate CREATE TABLE statements for tables

Access VBA Discuss using VBA for Access programming.

Welcome to the p2p.wrox.com Forums.

You are currently viewing the Access VBA section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com

April 3rd, 2005, 01:17 PM

method

Friend of Wrox

Join Date: Mar 2005

Posts: 264

Thanks: 0

Thanked 0 Times in 0 Posts

How to generate CREATE TABLE statements for tables

Hi Guyes. I want acomplish the following task in vba. I want make a form that has a button and
once i click on the button it generates "CREATE TABLE" statements (with defintion of all columns
and primary key and alternate keys) for tables in existence access db and writes them in to text file.
I be happy if some experts show me a working code since i am new to vba world. Thanks

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
how to generate tables using servlets	hafizmuhammadmushtaq	Servlets	1	April 14th, 2008 10:28 PM
Create random statements	ghall202	Access VBA	3	October 3rd, 2007 07:08 AM
Cannot generate insert statements in datasource	Maxxim	ASP.NET 2.0 Professional	1	July 6th, 2007 08:04 AM
How to create insert statements?	mooreeasyvibe	Excel VBA	0	August 31st, 2005 06:00 AM
How to generate ALTER TABLE statements for all for	method	Access VBA	3	April 5th, 2005 11:36 AM