[thelist] MS Access CREATE TABLE

[Ed McCarroll]

> Is there any way to generate CREATE TABLE scripts for all the tables in an
access
> database sorta the same way one can do this with SQL Server?

You should be able to do that with the query builder and/or VBA.  I
might be able to help if I better understood what you're doing:

1. From what are you trying to create the tables?

2. Do you need to automate the process in a script that does a
   "For each table ..." loop?

> Can't seem to find anything in Access "Help" (the paperclip ain't
> helping me much...) or on Google.

The MS Knowledge base is often useful:

  http://search.support.microsoft.com/kb/c.asp

HTH.

- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
Ed McCarroll                             http://www.ComSimplicity.com
ComSimplicity                                          (310) 838-4330
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -