i have written my company's stock system in an Access 2007 front end connecting to a MS SQL server for the Database.
I want to roll out Access 2010 and am testing it on the development machine.
There seem to be a couple of issues, but i have one that i can't get past.
In the database there is a main form. When that form is closed - it triggers the Form_Unload event.. and in that event the code Application.Quit is called and the application quits.
In Access 2007 and 2010 - if you close the main form the application exits properly.
in Access 2007 - if you click the click on the X button in the top right hand corner of the access application (not the main form), it causes the main form to close and the application.quit runs and the application exits properly.
in Access 2010 - if you click the click on the X button in the top right hand corner of the access application, it causes the main form to close but it ignores the application.quit code and continues past it and code runs that should not run.
can anyone explain why the Application.Quit is iqnored in Access 2010 when you close the database from the top right and X button?