I’ve posted a similar question but…

What I’m looking for is a way to see if a file is available and if so, run a macro; otherwise, if not available, display a message stating such.

I want to click a button on a form that will run some routine to see if “z:\database\sidewalks.mdb” is available. If yes, then run a macro called “macTransfer”; if not available, display a message “Network file is not available”.

Thanks,
SKK

SKK,

I saw your other post on this and thought Wayne Ryan gave you a pretty good answer: use the DIR function. Search here and in Access Help on how to use it. If you get stuck, post your code and I'm relatively sure someone will offer add'l help.

Regards,
Tim

Got it...

Thank eveyone very much for your assistance. Sometimes it's just too hard to teach this old dog new tricks.

Thanks again,
SKK