Adding a table to backend

[Silvester]

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]

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.