I have a macro that runs when my database opens. It checks to see if the
database is running in a trusted location. It then performs a saved import
to update its data. I need a condition to only run the import macro if the
file actually exists. My database is fairly simple but I have REALLY simple
users that can't handle a file not existing error message.

Thanks...
--
Allen Whitelock
Systems Administrator
World Class Automotive

Allen,

Try like this, for the Condition...
Len(Dir("C:\YourFolder\YourFile"))>0

--
Steve Schapel, Microsoft Access MVP


"Allen the Computer Guy" <(E-Mail Removed)>
wrote in message news:BC508FC6-FB5A-4203-8520-(E-Mail Removed)...
> I have a macro that runs when my database opens. It checks to see if the
> database is running in a trusted location. It then performs a saved
> import
> to update its data. I need a condition to only run the import macro if
> the
> file actually exists. My database is fairly simple but I have REALLY
> simple
> users that can't handle a file not existing error message.
>
> Thanks...
> --
> Allen Whitelock
> Systems Administrator
> World Class Automotive
>