Unanswered: Help suppressing save prompt and sql server error
I have a problem with suppressing a couple user prompts.
I have an access adp with a sql server backend and I'm displaying a view to a user view through the DoCmd.OpenView method. This is so that the user preview the data set and subsequently filter/sort or dump to excel or whatever.
My problem is that when you close the query data view you are prompted to save the query with the new filter settings. I don't want to save and I don't want the prompt.
I can hide this prompt using DoCmd.SetWarnings False which must default to an attempt to save the query/view which the user cannot do as they don't have permissions so this results in another prompt from the sql server which is something along the lines of "Object is invalid. Extended properties are not permitted on...." I've tried catching this error in the access application to do an 'On Error Resume Next' but I can't catch it anywhere.