Hi,

Can you not add:

On Error Resume Next

on the line before the line where the error appears and then:

On Error Goto 0

(or to wherever your errors were going before) on the line after?

If this works then a better solution would be to test the error value so
that you only ignore the error if it is for this specific reason, then if any
other error occurs an error message will still appear.

Hope this helps,

Sean.
--
(please remember to click yes if replies you receive are helpful to you)


"Sean" wrote:

I have a piece of code that extracts information from an access
database, everthing works well and I use this common file across
various locations. My problem is that a "cannot connect to database"
dialog box appears for a certain location. I know why this is, becase
it doesn't have the relevant access database. Thats okay, I don't need
it, but how could I 'ignore' this error when this error appears and
continue to run the remaining piece of code?

Thanks