I've spent most of the afternoon trying to find an answer to my question so please forgive me if I just didn't have the right keywords to find it via search.

I have several clients that use my database which is split into two parts, one of which is the data back end. At times I release upgrades to the whole package and must currently go through the process of having them get me the BE file and I manually make changes to tables and update data.

What I was hoping to do was create a seperate database that could link to the BE file, check for structure items and if they are missing add them. For instance if I have a new field I want to add to a table it will look for it, add it, and then if necessary add data. This way I could have one master file that I could send my clients and have them run it and not have to worry about the timing issues of transfering files back and forth.

Any guidance would be great. Not necessarily needing lengthy examples that would take a lot of your time to type out, simply want to know if it's possible and the basics that I can research and read up on.

Thank you in advance for your time! :)

>>> for structure items and if they are missing add them.<<<

It is possible to modify the table structures from another database, I have seen code for doing this somewhere but I can't find it at the moment if I do find I will post a link.

However your question suggest that you have a problem with the design of your database, if you expect to be adding fields on a regular basis, then that would indicate you have a set of fields that should be turned into a separate table.

I would suggest you study the threats linked to here: (http://www.access-programmers.co.uk/forums/showthread.php?t=143986)