Sql Code help please

[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

 

[Tim Ferguson]

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.

Yes: look up help for CREATE TABLE and ALTER TABLE. There are lots of
examples, and in any case the SQL is pretty close to standard, so any
database book will help too.

The syntax varies a little bit between versions and access methods: for
example using ADO you can set default values, which DAO doesn't.

Hope that helps


Tim F