Database Close abmormally

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • hshah
    New Member
    • Mar 2007
    • 10

    #1

    Database Close abmormally

    Hello all,

    Is there a way to run a function that will prevent backend database corruption when user exit database abnormally.

    I have hid all menus and title bar. STILL they are closing it.
  • MMcCarthy
    Recognized Expert MVP
    • Aug 2006
    • 14387

    #2
    Originally posted by hshah
    Hello all,

    Is there a way to run a function that will prevent backend database corruption when user exit database abnormally.

    I have hid all menus and title bar. STILL they are closing it.
    The easiest thing to do is to create an invisible form that opens with the database and create a proper exit application procedure in the unload event of the form. Then no matter how the application is closed the unload procedure of the invisible form will run.

    Mary

    Comment

    • hshah
      New Member
      • Mar 2007
      • 10

      #3
      [QUOTE=mmccarthy]The easiest thing to do is to create an invisible form that opens with the database and create a proper exit application procedure in the unload event of the form. Then no matter how the application is closed the unload procedure of the invisible form will run.

      Mary

      Thanks a million.

      One question on unload event "Application.Qu it acQuitSaveAll" will save data and close all connection to the backend. Correct?

      Once again Thanks a lot.

      Comment

      • MMcCarthy
        Recognized Expert MVP
        • Aug 2006
        • 14387

        #4
        Originally posted by hshah

        Thanks a million.

        One question on unload event "Application.Qu it acQuitSaveAll" will save data and close all connection to the backend. Correct?

        Once again Thanks a lot.
        You're welcome and yes that code should take care of it.

        Mary

        Comment

        Working...