>Is there someway to test if the DB is available?<BR>If you can connect to the DB wont it be available??<BR><BR>connection.state will tell you if you have a connection i guess...was that what you were asking...or am i telling you the price of ice in Alaska when you are asking me about the price of a can of beans.<BR><BR>>I'm looking for a way to redirect users to a page when the database is being updated<BR>You mean the updating takes soooo long that you want to display an intermediate page while it happens??
I don't know if there is a direct way to check this, but the simplest thing I can think of is to have a Function with On Error Resume Next in it. <BR><BR>You can try some sort of typical DB action within this function (open a connection, run a query) if this passes you know your DB is available, Function returns true, if it doesn't work, your function returns false.<BR><BR>If you are trying to determine the exact reason, you can check the error number and return something more meaningfull from your function.<BR><BR>-A