Allan,

>In my application, I have a global error handler that traps the most 'common' types of errors. This code resides in my start-up program.. However, for any other errors, I'd like to inform the user that an unexpected error has occured (I know how to do this) and then close all open tables, databases and forms before exiting the application.

>Question, what is a good method for determining the open forms and open databases, tables and cursors - and then closing them?

the function AUSED() gives you an array with all open tables.
the _Screen.Forms collection refers to all open forms.

tip: roll back all open transactions before trying to close the tables involved in it.

There is a good error handling document available from www.stonefield.com


Walter,