Checking ADO connection

[angelran]

Hi guys,
I have a problem with my ADO connection now. If the access data file is renamed or is moved to other location, how can i check that and give user a message (or redirect to other page) rather than display a system error page??

cheers

[Arnica]

Either use the FileSystemObject to ascertain the availability of the file or trap the database error and act accordingly. A search for FileSystemObject (http://www.google.com/search?q=FileSystemObject) and error handling in asp (http://www.google.com/search?q=error+handling+in+asp) will pull up a wealth of resources.

[BurgerKing]

Hi,

Here is a good link for how to check for the existence of your database file before attempting to connect to it.

http://www.aspemporium.com/codelib.aspx?pid=31&cid=5