Using Access for the front end provides the tools for rapid and flexible reporting. ODBC provides the connection to the back end database. SQL Server provides integrity and multiuser access, among other features. The worst limitations of Access are avoided.
With this modular approach, either piece can be changed to meet future needs. The front end can be replaced without affecting the database. The database can be replaced with little impact to the front end.
We use Access with an enterprise Oracle database. The database is part of an application that provides all of the data entry, analysis, and management. Access provides report flexibility that is lacking in the application.
Keep Up with TechRepublic