If statement depending if a file exists

[mike02]

Im working with my back end on dropbox. and the frontends on other peoples Pcs, Is there away to run an if statement stating,



If (the back end Locked* file exists), then
msgbox "Someone Is in the Database"

Else

docmd.OpenForm and so on.....(I know how to do this part

The reasoning is that it creates conflicting copies when you edit data from more then one Front End. and it is a pain to copy the conflicting data into the actual DB.

Thanks,

[pbaldy]

I'm not sure about using dropbox, but you can use the Dir() function to see if a file exists.