I am trying to convert Access 97 app to Access 2007 application. I am running into a problem with multi-users in the database. The multiuser application works fine in 97. But in 2007 when two users are in the database at the sametime one of users is always switch to the record the other user in working on. Any ideas how to fix this? I have tried splitting the database and making it executable file no luck.