Thread: Reconnect to SQL Server with VBA
10-11-04, 04:32 #1Registered User
- Join Date
- Oct 2004
Unanswered: Reconnect to SQL Server with VBA
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 ?