Results 1 to 2 of 2
  1. #1
    Join Date
    Apr 2009

    Unanswered: Help suppressing save prompt and sql server error

    Hello everybody!

    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.

    I'm stumped.

  2. #2
    Join Date
    Nov 2007
    Adelaide, South Australia
    Can't you close with the DoCmd.Close command, providing the "NoSave" argument?

    Just a first thought....
    Owner and Manager of
    CypherBYTE, Microsoft Access Development Specialists.
    Microsoft Access MCP.
    And all around nice guy!

    "Heck it's something understood by accountants ... so it can't be 'that' difficult..." -- Healdem
    "...teach a man to code and he'll be frustrated for life! " -- georgev

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts