I made my exe and put it in a test directory (with the necessary tables and other files) and everything worked fine. But then when I had a co-worker map to that directory and both of us use the app at the same time, none of our changes took.

I've got this app where basically two sets of records are shown on a form. They pick a record (or a few) from one side and then a few from the other side and then they click on match. What's supposed to happen is that these records are grouped together by use of a unique match number that gets inserted in all records chosen to be matched. I wrapped the entire matching process in a BEGIN TRANSACTION/END TRANSACTION combination but didn't do any other table buffering or anything. Maybe I need to? I thought there was some automatic buffering but maybe I'm wrong.

So what's happening is when I run the exe by myself the matches "take" and everything works fine. But when my co-worker and I do it, neither of our changes "take". So I'm obviously doing something wrong but I don't know what.

Any help (tutoring :) ) would be greatly appreciated.

Denise