Help, only one person can open an access database at a time. I believe it was created with office 2000 or 2003 but I'm not sure. Users using Office 2003 can only open it one at a time but two users with office 2007 beta version can open it anytime someone else has it open. It's default is set to open in shared mode and everyone has full control of the database in the security properties. This just started happening. Could it have something to do with office 2007 beta version. The person who opened it with that said they didn't convert the database.
Ok now I've narrowed down the problem to the fact that people who have access 2000 or 2007 can open any database while other users have it open no matter which version of access has it open but the users who have access 2003 can only open it if no one else has it open. Even if it is a user who originally opened it with access 2003 the second access 2003 user cannot open it.