We help IT Professionals succeed at work.

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

newbie46
newbie46 asked
on
324 Views
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.

thanks.
Comment
Watch Question

CERTIFIED EXPERT
Top Expert 2016
Commented:
Unlock this solution and get a sample of our free trial.
(No credit card required)
UNLOCK SOLUTION
CERTIFIED EXPERT
Commented:
Unlock this solution and get a sample of our free trial.
(No credit card required)
UNLOCK SOLUTION
Unlock the solution to this question.
Thanks for using Experts Exchange.

Please provide your email to receive a sample view!

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.