I'm still unable to well understand your problem (been working on such db apps more than 3years) . Establish your own rules of opening your database (for ex . exclusive use or not) and data entering (one or two or whatever at specific time with/out limited access ) . When you add new row , it will be added to the database (here you have to check first if it's existed already then prevent the user if not add new record ) . For me , I never consider what you posted as problem , never .