Code Efficiently: Use an MDA to Store a Common Access Code Library

摘要

I recently worked on a project that included upgrading half a dozen, different Access applications (some stand-alone and some using a shared back end), plus developing six applications―all as Access front-ends to a new SQL Server database. Not only did I encounter redundant data spread across the organization, I also found redundant code throughout the applications. Some applications had code that was performing the same task, but with different methods (e.g., Dlookup vs. Recordset code; Access-secured vs. do-it-yourself security, based on a table of employee names). Other applications had what appeared to be copies of the same functions, but with slight differences in code. After I normalized the data, I realized the code required some normalization as well.