I have a MS Access Project connected to a SQL Server 2000 database. When the connection is broken for some reason, I wish to trap the error and try to reconnect to the database.

Which error number(s) do I need to trap ?

How can I try to reconnect with VBA ?

Thx