Updating the definition of a live MS Access Database
Posted on 2008-06-23
I'm facing an awkward MS Access problem.
I developed an Access database that I will now deploy to a shared folder. About 10 users will have access to it. My problem is that no machines in the production environment have Access installed which means that I will make use of the Access run-time. (Thanks MS!!!). The problem comes in here: the defintion of the database will still need to change over the next few weeks or even months meaning new tables, queries, forms and reports have to be added still over time.
I will have to make these changes on my development machine off-site and then apply changes. Obviously I cannot just replace the AccDB file on the production machine because it contains live data. I also cannot make changes to the live database because there is no Access installation allowed and I will only be there a few hours each month.
Does MS Access 2007 provide a way in which I can transfer the changes in defition from my database to the live one?