Avatar of lhtila

asked on 

Access Database

I needed to place the reports in a separate database. I copied the front end and renamed it ...FE - copy. Created links to the back end tables; wrote an install script and Autoupdater.  Was this the best way to go?
Microsoft Access

Avatar of undefined
Last Comment
Avatar of crystal (strive4peace) - Microsoft MVP, Access
crystal (strive4peace) - Microsoft MVP, Access

creating a separate database with links to tables for reports is a good idea
Avatar of Gustav Brock
Gustav Brock
Flag of Denmark image

Blurred text
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
Long as your reports run correctly, it would seem that would be a good idea. I've had clients who wanted a reporting-only edition of their database, and that's what I'd do - copy all the reports to a new database, link the tables, and deploy that database.
Avatar of PatHartman
Flag of United States of America image

If the reports need to be in both FE's, I would do it differently.  Managing change in an environment were duplicate objects can exist in another FE is problematic.  You have to be very disciplined in how you handle changes.  I would separate the users into two groups, reporting only and all access.  The log on screen would check the user group and display a different menu for each type of user.  That way everything is in the same database and you only need to change it once.  You should always distribute as an .accde renamed to .accdr.  While that doesn't present much of a secure barrier to a technical person, it generally thwarts users and prevents accidents.
Microsoft Access
Microsoft Access

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.

Top Experts
Get a personalized solution from industry experts
Ask the experts
Read over 600 more reviews


IBM logoIntel logoMicrosoft logoUbisoft logoSAP logo
Qualcomm logoCitrix Systems logoWorkday logoErnst & Young logo
High performer badgeUsers love us badge
LinkedIn logoFacebook logoX logoInstagram logoTikTok logoYouTube logo