Re: Creating tables

Tech-Archive recommends: Speed Up your PC by fixing your registry

Hi Derichsweiler,

There are many ways to do it. I'd probably write code to assemble and
execute a SQL CREATE TABLE statement. If you go to the Access Help
contents page, click on "Microsoft Jet SQL Reference" and then "Data
Definition Language" you'll find the documentation.

Alternatively you can use the DAO.CreateTable method, but it seems
tedious by comparison.

On Wed, 17 Jan 2007 12:24:01 -0800, Derichsweiler
<Derichsweiler@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote:

is there any way to create tables programatically? I have tried createtable
and searching in the help file, but i cannot seem to find anything.

Thanks
Derichsweiler

--
John Nurick [Microsoft Access MVP]

Please respond in the newgroup and not by email.
.

Relevant Pages

  • Re: how do i use an sql script to create an access database
    ... Access can't run SQL scripts but can execute single DDL and DML ... execute the script a statement at a time. ... Help table of contents for "Microsoft Jet SQL Reference). ...
    (microsoft.public.access.modulesdaovba)
  • Re: MDB Bloats w/ RefreshLink
    ... In Access Help go to the table of contents and find ... Microsoft Jet SQL Reference, then Data Manipulation Language, then ... >> For each tablename in ... >> Please respond in the newgroup and not by email. ...
    (microsoft.public.access.modulesdaovba)
  • Re: Update Query Follow-up
    ... See Access Help on UPDATE Query / SQL ... Van T. Dinh ... With the update queries that I created, ...
    (microsoft.public.access.queries)
  • Re: Reference multiple tables for a value
    ... Take a look at Access HELP for particulars on the use of a UNION query. ... The rough outline is that you'll drop the ";" in the first SQL statement, ... add the word UNION and concatenate with the second SQL ...
    (microsoft.public.access.queries)
  • Re: Maximum Date Query Problem
    ... Check Access Help Topic "SQL SubQueries". ... Microsoft Access Help / Microsoft JET SQL Reference / Microsoft JET SQL ... > Yes Van, this one did work. ... Much thanks to you and John with the help. ...
    (microsoft.public.access.queries)