In an Access project, connected with a SQL Server database, users must reconnect using File/Connection after the connection is broken when a network error occured.

How can I do this automatically, using VBA and the settings on the Data Link Properties dialog box ?