time out for connection

[TjS]

Quite a simple question (but the answer may rather be large i suppose)

I use ms-access 2000
db is access based on oracle

a user works with the db in access for viewing reports and so on.
during the day access is open as application and the user is going to do something else. After returning to his/hers desk, and trying to use the access the connection is timed out (error message saying "cannot connect to database" or something simular.

This is not a problem, and i even think it is good that the connection is lost when no=one is working with the db.

However, i want to replace the 'standard' error message by a own made error message (let's say: user-friendly).

Don't know how to put this in code though.

Please advise,

Thanks in advance

 

[KeithG]

Do you get an error number? You could try and use the error event of the report to trap the error.