How do I prevent PivotTable Query from Being Saved

C

Craig M. Bobchin

Hi all,

One of the reports I've created in my Access app is a query in Pivot
Table view. the users love the "Ad Hoc" query nature of this so putting
it in a report is not an option.

We do have a problem however. Since there are multiple users of the db,
(the database is split, but both parts reside on the server pending all
users gettting updated to Access 2003) everyone sees the same version of
the query.

Is there any way I can prevent the query from being saved when the user
makes changes to the view and exits the query? Right now we are handling
it as a training issue.

I do know that once the FE is put on user's machines, eceryone will have
their own version of the query to do with what they want.

thanks

Craig
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top