[AccessD] SQL Server not found

http://www.sqlsecurity.com/Tools/FreeTools/tabid/65/Default.aspx
SQLPing3 Command Line
Doug - this tool may do the job for you....and hopefully respond much
faster.
Just shell out and call it from your Access start-up form.
Then parse the output file.


> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com
> [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Doug Steele
> Sent: Saturday, October 03, 2009 2:53 PM
> To: accessd at databaseadvisors.com
> Subject: [AccessD] SQL Server not found
>
> Hello all:
>
> I have an Access front end with a SQL Server express back
> end.  Occasionally the SQL Server isn't available.  I'd like
> the Access db to exit quickly and gracefully when this
> happens.  However, it takes about two minutes for the initial
> query to SQL server to fail and it fails with a screen asking
> the user to fill in the Server name.  Is there a quick way to
> find out if the server is available before I try to query it
> and to avoid getting the failure screens?
>
> Thanks,
> Doug Steele
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>