you could try Application.DisplayAlerts = False at the beginning of your
code, and Application.DisplayAlerts = True at the end.

"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