Access 2007 Query - "Do I wnat to Save"?

  • Thread starter Thread starter Ron
  • Start date Start date
R

Ron

Is there a way to Exit an Access Query without being asked "Do I wnat to Save"?

I do not want other users saving changes to my query, i.e. Sort Order,
deleting or adding field names, etc.
 
Is there a way to Exit an Access Query without being asked "Do I wnat to Save"?

I do not want other users saving changes to my query, i.e. Sort Order,
deleting or adding field names, etc.
Click to expand...

Well... then don't show them the query datasheet at all. It gives the users
both too little flexibility and too much power!

Instead, display the data in a Form or Report (for printing), and control that
object's Recordsource property.
 
John,
That's a good suggestion and I think I'll do just that.
But,
I really don't care if they modify the query to say sort by Vendor instead
of date, I just don't want the query saved, when they exit. I'd like to exit
the query without the message "Do you want to save query" appearing.
If that's not possible, then I'd propably create additional queries in
various sort orders and put those results into a form and/or Report.

Thanks for responding,
Ron
 
Back
Top