Adding a table to backend

message from Silvester on 6 May 2004
Hi,

I distribute my app as a secured mde fe and mdb backend.

How can I add a table or make structure changes to existing tables on the
end user mdb backend without overwriting their existing data ?
 
Douglas J. Steele replied to Silvester on 6 May 2004
I always use DAO, and commands like CreateTableDef and CreateField, although
you could also use ADOX.

For that matter, you can use DDL (Data Definition Language, which is run
like a query), and commands like CREATE TABLE, ALTER TABLE, CREATE FIELD and
ALTER FIELD.
 

Archived message: Adding a table to backend (Microsoft Access Error Message)