If your Access front-end is linked to a SQL backend, you will encounter a large number of errors and unsightly message boxes if the SQL Server connection is closed for whatever reason. Access should be able to recover gracefully from this common problem, rather than bombard the user with dialogs. Read more information about this issue.