alter table, create table, drop column

[John]

Hello,

I am very new to access. We have a application that is out of a pc
tablet and currently when we have updates to the access database we have to
actually go in it and modify the table structure. I am want to know if there
are sql commands that can create, drop, alter tables/columns so we can run a
generic type auto update application opposed to doing it manually. Can I get
a sample of how to do it in access? Is there links to samples running sql
code to do create/alter/drop commands in access? Thanks in advance.

John

 

[Allen Browne]

This article demonstrates the common DDL statements for Access:
http://support.microsoft.com/default.aspx?scid=kb;en-us;180841&Product=acc2000

However, it should not normally be necessary to modify the table structure
constantly. If you have a normalized data structure, it should be quite
static, so you may want to read up on normalization.