Avatar of DatabaseDuane
DatabaseDuane
 asked on

Custom Report and Query Building For Clients in Access

I have users of an access db who would like to have the option to build reports and queries. I wonder if there are any 3rd party tools or suggestions on ways to let end-users get into report building that doesn't threaten the data.
Microsoft Access

Avatar of undefined
Last Comment
Badotz

8/22/2022 - Mon
ASKER CERTIFIED SOLUTION
Patrick Matthews

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question
SOLUTION
Jeffrey Coachman

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question
DatabaseDuane

ASKER
Understood that reports themselves don't effect data. I imagine them creating queries for the reports that could wreak havoc. An ideal solution would be a back-end interface that only allows for display-only queries (no updatable queries). Perhaps there is a way to customize a back-end interface to give that type of choice?
Jeffrey Coachman

Again, ...What is your experience with MS Access?

Judging form what you just posted, I suggest you do a bit more research on MS Access database design.

<"I imagine them creating queries for the reports that could wreak havoc.">
As long as the DB is not secured, this possibility will always exist.
Only if the users modify the data via the query could they possibly "wreak havoc".
Is your concern that a user will do this accidentally, or are you concerned with a "Malicious" user.
I mean, if you don't trust the users, then perhaps they should not be making reports...?

<An ideal solution would be a back-end interface that only allows for display-only queries (no updatable queries)>
No, not really,... an "ideal solution" would be a database that is "Secured".
There is no *direct* way to make a query Read-only.
(you can do this, but again, there are other techniques, depending on exactly what you need.)


The goal here is user education.
Users should be educated on how a basic database functions, and what they should or should not be doing.
Also appropriate safeguards should be in place to limit the amount of "Havoc" a user can wreak.

But this is another topic altogether...


;-)

JeffCoachman

SOLUTION
Log in to continue reading
Log In
Sign up - Free for 7 days
Get an unlimited membership to EE for less than $4 a week.
Unlimited question asking, solutions, articles and more.
SOLUTION
Log in to continue reading
Log In
Sign up - Free for 7 days
Get an unlimited membership to EE for less than $4 a week.
Unlimited question asking, solutions, articles and more.
DatabaseDuane

ASKER
Sounds like there are no tools readily available that allow for a safe "playground" for end-users. The best solutions I hear are to create alternate data for them to use and potentially wreck.

Thanks for the help and I'll split the points.
All of life is about relationships, and EE has made a viirtual community a real community. It lifts everyone's boat
William Peck
Badotz

matthewspatrick: Of course, I wasn't thinking clearly...it's been a long day, and it's only 9:36 AM ;-)
Badotz

Oh, and no worries, DatabaseDuane - glad to help.