Access VBA Run codein a backend database

Hi

I have to split an old database and then apply table name changes to the backend Access file that is created and then hook it in to a new front end. This involves table name changes and addition of columns. I have to do this very quickly online during a conference  call. My plan is to split the old database and then run VBA code in the new backend to change the table names etc. Does this sound like a good approach?

Thanks