Hi,
I inherited 6 databases that do the same thing for different business units. They are littered with ad hoc queries and make tables over the past 10 years and am looking to start clean. Since they all do the same function my plan is to consolidate to one database, front/back end. The frontend users will basically add projects to a table with all detail (amount, funding project, vendor, etc….) based on their business unit. Other than this form they may have a couple of queries to look things up but their functions are pretty limited. My function is to run actual results against these projects which requires a lot of queries, make tables, macros, etc… that are run weekly.
My thought is I start with a blank database and build only the tables, forms and queries related to the front end, split it, then continue to use the backend for my maintenance queries, macros, etc… But…. Everything I’ve read about splitting a database says only the tables remain in the backend. Should I just be creating another front end for my maintenance as well? Any guidance to help me design right out of the gate would be really appreciated!!
Thanks!
Eric