Should forms, reports, macros, modules ever be in the back end of a split Access database?

Posted on 2011-04-26
Last Modified: 2012-05-11
I have acquired an Access 2007 database. It is split into a front end and a back end. The back end contains forms, queries, reports, macros, and modules. Most of these are the same as what is in the front end and some are unique only to the back end.

I have never seen a database which stores forms, etc, in the back end. My question is this:
Is there ever a good reason to set up a database like this? The back end forms import data from
Excel. I have always put this functionality in the front end.

Did this developer misunderstand the meaning of front end/back end or is there some logical reason for setting up a split database with forms, reports, macros, etc in both the front end and back end.

Question by:newbie46
    LVL 119

    Accepted Solution

    he probably forgot to remove the objects aside from the tables in the BE.

    see this link, for reasons why you have to split an application
    LVL 77

    Assisted Solution

    I suspect that it was just a mis-op by the developer.
    Possibly they created the front-end by importing objects from the complete application file and then used the original file as the backend.

    The backend might hold objects required for maintenance and support but in terms of 'live' objects, generally I would only expect to find  tables in the backend.


    Featured Post

    How your wiki can always stay up-to-date

    Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
    - Increase transparency
    - Onboard new hires faster
    - Access from mobile/offline

    Join & Write a Comment

    In the article entitled Working with Objects – Part 1 (, you learned the basics of working with objects, properties, methods, and events. In Work…
    I originally created this report in Crystal Reports 2008 where there is an option to underlay sections. I initially came across the problem in Access Reports where I was unable to run my border lines down through the entire page as I was using the P…
    As developers, we are not limited to the functions provided by the VBA language. In addition, we can call the functions that are part of the Windows operating system. These functions are part of the Windows API (Application Programming Interface). U…
    Using Microsoft Access, learn some simple rules for how to construct tables in a relational database. Split up all multi-value fields into single values: Split up fields that belong to other things into separate tables: Make sure that all record…

    746 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    17 Experts available now in Live!

    Get 1:1 Help Now