Access VBA Run codein a backend database

Murray Brown
Murray Brown used Ask the Experts™
on
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
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Most Valuable Expert 2012
Distinguished Expert 2018
Commented:
Depending on the changes you had to make, create views in the new database that matches the old table names.  Then you may not have to change the back end database at all.
John TsioumprisSoftware & Systems Engineer
Commented:
If you test it enough and you have some kind of backup plan you should be fine....but don't do it without having a plan B...these cases are all about Murphy's Law
Murray BrownASP.net/VSTO Developer

Author

Commented:
thanks for the advice

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial