Can a switchboard be used to display an Access query?

[Guest]

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.

 

[Joseph Meehan]

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.

Just add a button to run query.

 

[Guest]

Running a query from the switchboard will bring up a datasheet view, that can
then be exported to Excel. For added safety, make sure that the database you
distribute is a MDE file, so that your users cannot modify the query design