How do you set a Microsoft Access file to alert you when someone else has the file open AND still allow you to open it in read only mode? I have 3 people in my department and we all need to be able to edit the database at any given time. However, right now we have no way of knowing when someone else is in the database.