Programmatically add a field to an existing table

[lpdds]

I have a simple front end/back end application that I have distributed to different locations (each locations has it's own application). I need to modify the design of a table by adding several fields. Since I don't have direct access to the back end databases, and cannot rely on someone at each location to manually add the fields, I need a way to programmatically add the fields. Is this possible?

[dcrake]

The best way to do this is to create a new mdb that contains the correct table structure. Have a simple wizard that appends all records from the remote mdb table into the new structure then get it to export the table back to the remote back end which will overwire the existing one.

Having said that this may work if relationships are in place in the remote back end (Which they should not be).

David

[lpdds]

Thank you. I will try it.