>I am running an app that uses an alias to refer to a table. When I run a report I want to check and make sure that a file is open and the alias is being used else show a message box saying that a file is not open. If it is, then the report should run. I have tried quite a few ways to get this done, but with no luck. The alias is the cause of my trouble. If it were just a filename, I could do this. Any ideas?

Do you know what the alias is? If you do, you can just check with the USED() function.