This one should be simple for you pros. I have a database that resides in an eRoom that only employees of the department can access. I had to put the database here because it is the only area shared by the entire department. That being said, the eRoom has some functional limitations. One being, it will not save changes if more than one person is working in the database at the same time unless you right click on the access key and select edit. I want to set an on open warning for those individuals that try to access the database by simply clicking on it.

Can someone tell me how I can do this?

Thank You!!