Splitting Microsoft Access Databases to Improve Performance and Simplify Maintainability
http://www.fmsinc.com/microsoftaccess/databasesplitter/index.html
icrosoft Access lets you easily create databases to store and present your data in forms and reports. When starting, a database may be very simple and trivial, but over time, it may become more critical as you add more data, features, and even share it with others. It gains a life of its own and the overall design becomes critical.
One of the most important architectural designs is splitting the database into a front-end and back-end database. This is the way Access was designed to let you support multi-user databases and significantly simplify how you enhance the application over time.