determine if SQL Server is running

[NightZEN]

I am trying to determine, via vba, if ther SQL server is running or available. Does anyone have an easy method to do this? I am writing a routine to handle either the SQL Server being down, or the user running the database off the network (ie, a laptop on the road).

Thanks for any thoughts or ideas!

 

[mp9]

In your code, try attaching to a database table on the SQL server. Use error handling to catch the error code if the server is down, and take appropriate action.

http://www22.brinkster.com/accessory/