Important Notice: Our web hosting provider recently started charging us for additional visits, which was unexpected. In response, we're seeking donations. Depending on the situation, we may explore different monetization options for our Community and Expert Contributors. It's crucial to provide more returns for their expertise and offer more Expert Validated Answers or AI Validated Answers. Learn more about our hosting issue here.

Can a switchboard be used to display an Access query?

April 26, 2017display query switchboard Used

0

Posted

Can a switchboard be used to display an Access query?

1 Answer

0

Posted

I want to create an easy way for my users to gain access to the database data, but without requiring them to go into the actual db interface. I’m aware of how to display “reports” using the switchboard functionality, but I want to display the actual query results so that users will have the option to copy/paste the results into an Excel file if they choose. Is there an easy way to create a user front-end that will let them point and click on a list of queries, but prevent the users from gaining access the actual database? I’m using MS Office Access 2003. Thanks for your help.