Table design Updates

[Jim Tanis]

1. I have set up a DB in access 2003 (ac200 format). I have split the db to
front/back end. Installing a new version of the front end is easy. Copy -
paste - replace. But for the backend??
Let's say I want to change a table (in the backend). What is the best way to
incorporate the change in a working copy (not replica) of the db??
1) through DAO?
2) through ADO?
3) through data definition query?

And how is this done? (hope I'm not asking to much)

It would be best for me to work a way to apply changes without 2firure lines
of code, cause updates are to be released frequently.

2. I have a set of linked and imported tables in a db. Is it possible to
"edit" the link/import properties??? So far each time I want to change
something in the link, I delete the table and relink/reimport it. :-(

Thanx in advance

 

[Allen Browne]

DAO is the language that Access itself uses behind the scenes, so the best
language for working with Access tables. Some of the properties of the table
and fields can only be set through DAO, e.g Format and Caption. ADOX is
still to buggy to use IME, and DDL is useless as you cannot even set crucial
properties such as AllowZeroLength.

If you cannot just go to the site where the back end is in place or open the
file directly, one approach is to write an "updater" database, which
contains the code to create/delete/modify the fields, indexes, tables,
relations, and the properties of each.

Re q.2, you can just set the Connect property of the TableDef and RefeshLink
to reassign where an attached table gets its data from.